Problem $2$: Submit your Excel flue to show how you work out the problem with Excer functions and cell references. $($Excel part $10$ points$)$

In the Excel, please do the following:

fi$)$ Prease construct your proforma income statement and balance sheet.

$(2)$ Show how you calculate EFN with Pro Forma statements

$(3)$ Show how you verify EFN with the formula

The Optical Scam Company has forecast a saies g owth of $25$ percent for next year the current financial statements are shown here:

$\backslash$table$[[$Income Statement$],[$Sales$,,5],[,,31,302,000],[$Costs$,,25,858500],[$Taxable income,,$5],[$Taxes$,,5,443,500],[,,1,905375],[$Net Income,,$$3\mathrm{.}538\mathrm{.}275],[$Dividends Addition to retained,$ $1,415,310,],[$earengs$,2,22,065,]]$

$\backslash$table$[[$Balance Sheet$],[$Assets$,,$Liabities and Owners',$],[$Current assets,,Equity,$],[,$$$7,290,000,$Accounts payabie,$$6\mathrm{.}866\mathrm{.}000],[$Floed assets,$19,002\mathrm{.}000,,4,382\mathrm{.}000],[,,$Common stock Accumulated retained earnings,$ $3788\mathrm{.}000],[,,$Total equity,$$15,024\mathrm{.}000],[$Total assets,$ $26.$ samarna,Total lubuties and equity,$$26,292\mathrm{.}000]]$

Prease show how you work on the following questions in the eacel flee. as point

$($t$)$ Please concinuty your frod serm micolic slatement and barance whent

$($a$)$ Show how you calculate EFN with Pro Forma stabements

$($i$)$ Show how you venty CFN was the formula

a$.$ Using the equation from the chaplec, calculate the external friancing needed for neat year. $($Do not round intermediete calculations and round your answer to the feerestb$-$ Construct the firm's pro forma balance sheet for next year $($Do not round

Intermedlate calculations and round your answers to the nearest whole number, e$.$g$.,32.$