2. More on the AFN (Additional Funds Needed) equation Green Moose Industries reported sales of $743,000 at the end of last year, but this year, sales are expected to grow by 6%. Green Moose expects to maintain its current profit margin of 20% and dividend payout ratio of 30%. The following information was taken from Green Moose's balance sheet: Total assets: Accounts payable: Notes payable: Accrued liabilities: Based on the AFN equation, the firm's AFN for the current year is $425,000 $75,000 $25,000 $60,000 A positively signed AFN value represents: OA shortage of internally generated funds that must be raised outside the company to finance the company's forecasted future growth. 71.2% oint at which the funds generated within the firm equal the demands for funds to finance the firm's future expected sales uirements. 62.3% 80.1% urplus of internally generated funds that can be invested in physical or financial assets or paid out as additional dividends. 89.0% Bec excess funds, Green Moose Industries is thinking about raising its dividend payout ratio to satisfy shareholders. Green Moose could pay of its earnings to shareholders without needing to raise any external capital.(Hint: What can Green Moose increase its dividend payout ratio to before the AFN becomes positive?) out

is there a way to do this question with formulas and a calculator instead of excel? if so please upload the solution this way

Further info is in the attached images For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B34 enter the formula "= B9". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50. Thank you!

Please help on parts 4 and 5. Please also show work on how to do.