I have done the work. Just need my answers checked that are in yellow. Thank you.
Other Inputs Tax rate Growth rate Capacity Utilization 40% 15% 95% Input GEM, Inc. 2017 Income Statement 4 Sales 50,000,000 5 COGS 35,000,000 6. Other expenses 5,105,100 7 Depreciation 1,804,220 8 EBIT 8,090,680 9 Interest 630,520 10 Taxable income 7,460,160 11 Taxes (40%) 2,984,064 12 Net income 4.476,096 14 Dividends 15 Add to RE 610,000 3,866,096 20 Current Assets 21 Cash Accounts rec. 23 Inventory Total CA GEM, Inc. Balance Sheet as of December 2017 El Liabilities & Equity Current Liabilities 456,435 Accounts Payable 733,125 Notes Payable 1,073,180 Total CL 2,262,740 Long-term debt 929,005 2,121,350 3,050,355 5,500,000 28 Fixed assets 29 Net PP&E Shareholder Equity Common stock Retained earnings Total Equity 17,723,430 400,000 11,035,815 11,435,815 32 Total Assets 19,986,170 Total L&E 19.986.170 36 Calculation & Output 37 Question 1 38 Return on assets 39 Return on equity 40 Dividend payout ratio 41 Retention ratio 22.000 39.1456 13.6354 0.86 43 Internal growth rate 44 Sustainable growth rate 23.95 51073 52,631.578.95 46 Question 2 GEM, Inc. Proforma Income Statement 49 Sales 52 500,000 50 COGS 40,250,000 51 Other expenses 5,870,865 52 Depreciation 1801.220 53 EBIT 9.574,915 54 Interest 630.520 55 Taxable income 8.944,395 56 Taxes (40%) 31572.758 57 Net income 5.366.637 Fixed Asset Calculation Full capacity sales Fixed assets/sales at full capacity Total fixed assets 35294723 59 Dividends 60 Add to RE 731.362 4,635,275 ' Assets 65 Current Assets 66 Cash Accounts rec. Inventory Total CA GEM, Inc. Proforma Balance Sheet Liabilities & Equity Current Liabilities Accounts Payable Notes Payable TotalCL 524,900 843,094 1,234,152 2,602,151 1,068,356 2.121.150 219.206 $ Long-term debt 5.500.000 71 Fixed assets Net PP&E 19362.847 100 000 Shareholder Equity Common stock Retained earnings Total Equity 22.358,705 77 Total Assets 21.06.998 Total L&E I 1410 79 EFN Task 1 Financial Planning Task 2-Time value of money Task 3-DCF Task 4 Loan amortization