Kindly help me answer this and please help with having the formulas for how you get the answers aswell

L | i Heme Insert Draw Page Delete Calbri Body Balance Sheet as of December 31, 2018 Invome Statement, Year Ended December 11, 201 Labilites ales Revenue Cost of Goods Sold Gress Proft s 30,000,000 21,000.000 Current Assets $ 1,000,000 3,000,000 12,000,000 Accounts Payable Notes Payable 8,0co,0o0 8,000,000 Marketable s Operating xpenses Accounts Recelvable eling Expense 5 3,000,000 Geneal& Administrative Expees etories Total Current Assets Long-Term Debt Stockholders' Equity 0,000,000 9Lease Expese Depreciation Expense 2,500,000 9,000,000 2.000,000 11 Total Oper ating Expense 6,000,000 Net Fixed Assets $ 26,500,000 Operating Profe 3 Inderest Expense 4 Net Proft before Common Stock & Paid-ln Surplus Retained Earnings 5 2,000,000 800.000 Total Stockholders Equity 13,500 000 Taes 5 Taxes (40%) Net Proft ater Tases Total Assets Total Labilities & Equity Muk pays 2 10% ores ser,term debt and 416%onitslengtermdebt These "ates are enpected to hold for the new tutve. The company reeds to plan for a 10% rew" n sale" for the year 2019. Assume al operating espenses will rise at the same rndluding ese espense Metalic has a stable dividend payout ratio ef 50% Assume that the fom is at full capaity sales, and that capital is not lumpy gories of current ansets Onding maketable securities) are expected to grow at the same rabe as sales Consider Atcounts Payable&Accruals to be sportaneous labiltie Hat of any new faning wil be raued shreugh short serm delt, and half through long term debt No prinopal pay down is espected in the coming year Qvestion Draw Page Layout Formulas Data Review View Tell me what you want to do Home Insert 21|The onpany needs to plan for # IONFowth in sm ser heyew 2019 23 Metalic has table dividend payout rate of 50% 24 Assume that the frm is at full capacity saies, and that capital s sot lumpy Hall of any new fsaning will be rised through shos-erm deb and hall threugh ongd 28 No princigal pay down is expected in the coinE 0 Question Make sure to set up the ssunmptions bo" tollewed by the prejncted 2019 incme stement &er , 2019 ht Then,use the sreadsheet feature of automated to olve for KINDLY USE ONE EXCEL FILE, BUT A SEPARATE SHEET FOR EACH QUESTION! 14 15 Question 2 6 Estimate EFN under the sane asunptons as above, but this e use the diret memod 40 Please make sure to show your work clearly L | i Heme Insert Draw Page Delete Calbri Body Balance Sheet as of December 31, 2018 Invome Statement, Year Ended December 11, 201 Labilites ales Revenue Cost of Goods Sold Gress Proft s 30,000,000 21,000.000 Current Assets $ 1,000,000 3,000,000 12,000,000 Accounts Payable Notes Payable 8,0co,0o0 8,000,000 Marketable s Operating xpenses Accounts Recelvable eling Expense 5 3,000,000 Geneal& Administrative Expees etories Total Current Assets Long-Term Debt Stockholders' Equity 0,000,000 9Lease Expese Depreciation Expense 2,500,000 9,000,000 2.000,000 11 Total Oper ating Expense 6,000,000 Net Fixed Assets $ 26,500,000 Operating Profe 3 Inderest Expense 4 Net Proft before Common Stock & Paid-ln Surplus Retained Earnings 5 2,000,000 800.000 Total Stockholders Equity 13,500 000 Taes 5 Taxes (40%) Net Proft ater Tases Total Assets Total Labilities & Equity Muk pays 2 10% ores ser,term debt and 416%onitslengtermdebt These "ates are enpected to hold for the new tutve. The company reeds to plan for a 10% rew" n sale" for the year 2019. Assume al operating espenses will rise at the same rndluding ese espense Metalic has a stable dividend payout ratio ef 50% Assume that the fom is at full capaity sales, and that capital is not lumpy gories of current ansets Onding maketable securities) are expected to grow at the same rabe as sales Consider Atcounts Payable&Accruals to be sportaneous labiltie Hat of any new faning wil be raued shreugh short serm delt, and half through long term debt No prinopal pay down is espected in the coming year Qvestion Draw Page Layout Formulas Data Review View Tell me what you want to do Home Insert 21|The onpany needs to plan for # IONFowth in sm ser heyew 2019 23 Metalic has table dividend payout rate of 50% 24 Assume that the frm is at full capacity saies, and that capital s sot lumpy Hall of any new fsaning will be rised through shos-erm deb and hall threugh ongd 28 No princigal pay down is expected in the coinE 0 Question Make sure to set up the ssunmptions bo" tollewed by the prejncted 2019 incme stement &er , 2019 ht Then,use the sreadsheet feature of automated to olve for KINDLY USE ONE EXCEL FILE, BUT A SEPARATE SHEET FOR EACH QUESTION! 14 15 Question 2 6 Estimate EFN under the sane asunptons as above, but this e use the diret memod 40 Please make sure to show your work clearly