Question: In Excel complete the vertical size statement analysis for the statement below and also create a pro forma assuming an 8% growth and also assuming

In Excel complete the vertical size statement analysis for the statement below and also create a pro forma assuming an 8% growth and also assuming that rent is fixed. Once completed upload the completed Excel to this question. Your Awesome Business Name Income Statement For the Perio! Ended December 31, 2019 Sales Revenue Cost of Goods Sold Gross Profit $90,000 32,000 $58,000 OPERATING EXPENSES Marketing Utilities Insurance Rent Expense Wages & Salaries Total Expenses $1,800 750 1,000 12,000 25,000 $40.550 OPERATING INCOME $17.450 $100 NON OPERATING, OTHER Interest Income Interest Expense Gain/(Loss) (750) 1000 Profit before tax $17,800 Income Tax Expense 3,740 NET INCOME $14,060
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
