Question: 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

 Using an Excel spreadsheet calculate the bottom line improvement using the

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, Communicate with your instructor if you have difficulties. Base Line Financials Item Base Line Sales $100,000 Cost of goods sold $80,000 Gross margin $20,000 Finance costs $6,000 Subtotal $14,000 Taxes at 25% $3,500 Contribution $ 10,500

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!