Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a 5 year revenue forecast using the textbook for this course to assist you, page 31 has an example and I have provided the

Create a 5 year revenue forecast using the textbook for this course to assist you, page 31 has an example and I have provided the template below to help you.

Week 2 - Template.docx

Create information for the company of your dreams. Show five years of data.

This is a simple revenue forecast,

  1. Provide an explanation of what assumptions you use to come up with revenue, then explain how revenue will be adjusted for the next four years. This means provide the numbers you use to calculate revenue.
  2. Provide an explanation of what assumptions you use to come up with cost of goods sold (if used), and expenses for the first year. Then explain how COGS and expenses will be adjusted for the next four years. This means provide the numbers you use to calculate COGS and expenses.
  3. Make sure you address all the accounts required Revenue less Cost of Goods Sold (not required for service company) equals Gross Profit Margin less Operating Expenses equals Net Profit.
  4. Be consistent throughout the budget, display and explain your calculations (show your numbers).

Year 1

Year 2

Year 3

Year 4

Year 5

Total Revenue

Cost of Goods Sold

Gross Margin

Operating Expenses

Profit (Loss) Before Taxes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Real Estate Finance

Authors: David Sirota, Doris Barrell

14th Edition

1475428391, 9781475428391

More Books

Students also viewed these Finance questions