Could you assist with showing a spreadsheet to model the financial results for 2024-2030? Can it also be made to allow for change so we can run different scenarios? The spreadsheet should have for each year: Revenue, Cost of Goods Sold, Gross Margin, Sales, General and Administrative Costs and Net Profit. The model created must allow for flexibility, i.e., a change in assumptions so that different scenarios can be run. Revenue for 2023 was 2.5 million in 2024 its expected to increase 8.9% from 2023 for 2025 to 2040 is projecting annual revenue increases of 7.5% costs of good sold is calculated as a percentage of revenue and is estimated at 34% of revenue in 2024 for 2025 to 2030, costs of good sold is expected to decrease by 3.0% per year Sales, General and Administrative expenses are expected to be 60% of revenue in 2024 for 2025 to 2030 sales, general and admin costs are expected to decrease to 45% of revenue
Could you assist with showing a spreadsheet to model the financial results for 2024-2030? Can it also be made to allow for change so we can run different scenarios? The spreadsheet should have for each year: Revenue, Cost of Goods Sold, Gross Margin, Sales, General and Administrative Costs and Net Profit. The model created must allow for flexibility, i.e., a change in assumptions so that different scenarios can be run. Revenue for 2023 was 2.5 million in 2024 its expected to increase 8.9% from 2023 for 2025 to 2040 is projecting annual revenue increases of 7.5% costs of good sold is calculated as a percentage of revenue and is estimated at 34% of revenue in 2024 for 2025 to 2030, costs of good sold is expected to decrease by 3.0% per year Sales, General and Administrative expenses are expected to be 60% of revenue in 2024 for 2025 to 2030 sales, general and admin costs are expected to decrease to 45% of revenue
Chapter9: Responsibility Accounting And Decentralization
Section: Chapter Questions
Problem 1PA: Use the following information to answer the questions that follow. A. Calculate the operating income...
Related questions
Question
Please correct answer and don't use hand raiting
Transcribed Image Text:Could you assist with showing a spreadsheet to model the financial results for 2024-2030? Can it also be made to allow
for change so we can run different scenarios? The spreadsheet should have for each year: Revenue, Cost of Goods Sold,
Gross Margin, Sales, General and Administrative Costs and Net Profit. The model created must allow for flexibility, i.e., a
change in assumptions so that different scenarios can be run.
Revenue for 2023 was 2.5 million
in 2024 its expected to increase 8.9% from 2023
for 2025 to 2040 is projecting annual revenue increases of 7.5%
costs of good sold is calculated as a percentage of revenue and is estimated at 34% of revenue in 2024
for 2025 to 2030, costs of good sold is expected to decrease by 3.0% per year
Sales, General and Administrative expenses are expected to be 60% of revenue in 2024
for 2025 to 2030 sales, general and admin costs are expected to decrease to 45% of revenue
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,