Using an Excel spreadsheet, calculate the bottom line improvement using the base line below under these scenarios
Learning Goal: I’m working on a business question and need guidance to help me learn. Using an Excel spreadsheet, calculate the bottom line improvement using the base line below under these scenarios:Increase sales by 50%
Reduce finance costs by 50%, keeping sales at $100,000
Reduce production costs by 20% (cost of goods sold), keeping sales and finance costs at the initial levels
What option offers the best overall result? Upload the Excel file with your calculations.
Base Line Financials Item Base LineSales$100,000Cost of goods sold$80,000Gross margin$20,000Finance costs$6,000Subtotal$14,000Taxes at 25%$3,500Contribution$ 10,500
Requirements: no requirement | .xls file
