Scribd
Upload
11 views3 pages

Sales and Profit Forecast Analysis

Uploaded by

Erico Augusto do Carmo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views3 pages

Sales and Profit Forecast Analysis

Uploaded by

Erico Augusto do Carmo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

PARAMETERS

DECISIONS

OUTPUTS

CALCULATIONS
2013 2014 2015 2016 2017
Sales $10,000,000
Sales Growth 5% 10% 10% 10%
Gross Margin % 50% 50% 51% 52% 53%
Fixed Costs $6,000,000

Fixed Cost Growth -5% 0% 5% 5%

Expected Profit ($1,000,000) ($450,000) $190,500 $621,600 $1,122,765

Sales Forecast $10,000,000 $10,500,000 $11,550,000 $12,705,000 $13,975,500


Gross Margin ($) $5,000,000 $5,250,000 $5,890,500 $6,606,600 $7,407,015
Fixed Costs $6,000,000 $5,700,000 $5,700,000 $5,985,000 $6,284,250
Profit ($1,000,000) ($450,000) $190,500 $621,600 $1,122,765

You might also like