Question: can you please fill this out and explain step by step where it comes from? Build - Income Statement, Balance Sheet & Statement of Cash
can you please fill this out and explain step by step where it comes from?

Build - Income Statement, Balance Sheet \& Statement of Cash Flow Read and fill in the assumptions Use Formulas and link the ASSUMPTIONS to the I.S. and B.S. and C.F. where possible. The 3 financial statements should be linked. For example, if sales were to change, then all 3 statements will change. If something is missing, identify it and add it to the model Assumptions Revenue Grows +3% to prior year COGS is 65.87 percent of sales each year SGA is 17.41% percent of sales each year Depreciation expense is Capital Expenditures are Debt maturities are $1,396.50 each year No new Long Term debt Dividends Paid are $500 each year Interest Rate on debt Tax Rate Build - Income Statement, Balance Sheet \& Statement of Cash Flow Read and fill in the assumptions Use Formulas and link the ASSUMPTIONS to the I.S. and B.S. and C.F. where possible. The 3 financial statements should be linked. For example, if sales were to change, then all 3 statements will change. If something is missing, identify it and add it to the model Assumptions Revenue Grows +3% to prior year COGS is 65.87 percent of sales each year SGA is 17.41% percent of sales each year Depreciation expense is Capital Expenditures are Debt maturities are $1,396.50 each year No new Long Term debt Dividends Paid are $500 each year Interest Rate on debt Tax Rate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
