Homework Help is Here – Start Your Trial Now!
Business
Finance
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

Principles of Accounting Volume 2
Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
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...
See similar textbooks
icon
Related questions
Question
Please correct answer and don't use hand raiting
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
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
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L…
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS