4 Calculating EFN - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA ? REVIEW VIEW...

 

Transcribed Image Text:

4 日 Calculating EFN - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA ? REVIEW VIEW Calibri Paste 11 A A % M BIU Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Clipboard G A1 AB C Font fx D E F G H - Sign In K 4356 N Income statement Balance sheet 7 Sales $ 7,600 Assets $ 00 8 Costs 5,180 21,700 Debt $ Equity 9,100 12,600 9 Net income $ 2,420 Total $ 21,700 Total $ 21,700 10 12 1234 13 11 Next year's sales $ 8,968 14 Complete the following analysis. Do not hard code values in your calculations. 15 16 Percent increase in sales 17 18 Pro forma income statement 19 Sales 20 Costs 21 Net income 22 23 External financing 24 25 26 27 4 Sheet1 + Assets Pro forma balance sheet Debt Total Equity Total 4. 4 日 Calculating EFN - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA ? REVIEW VIEW Calibri Paste 11 A A % M BIU Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Clipboard G A1 AB C Font fx D E F G H - Sign In K 4356 N Income statement Balance sheet 7 Sales $ 7,600 Assets $ 00 8 Costs 5,180 21,700 Debt $ Equity 9,100 12,600 9 Net income $ 2,420 Total $ 21,700 Total $ 21,700 10 12 1234 13 11 Next year's sales $ 8,968 14 Complete the following analysis. Do not hard code values in your calculations. 15 16 Percent increase in sales 17 18 Pro forma income statement 19 Sales 20 Costs 21 Net income 22 23 External financing 24 25 26 27 4 Sheet1 + Assets Pro forma balance sheet Debt Total Equity Total 4.

Answer rating: 100% (QA)

To complete the analysis lets proceed step by step 1 Percent increase in sales Calculate the percent... View the full answer