What is the annual percentage increase?
Malay Adventures Financial Projection Table |
||||||
FY2019 |
FY2020 |
FY2021 |
FY2022 |
FY2023 |
Annual % Increase |
|
Sales Forecast |
||||||
Individual Customers |
$1,140.00 |
$2,450.00 |
$4,140.00 |
$5,550.00 |
$7,140.00 |
|
Business Organizations |
$62,100.00 |
$72,100.00 |
$82,100.00 |
$92,100.00 |
$102,100.00 |
|
Total |
$63,240.00 |
$74,550.00 |
$86,240.00 |
$97,650.00 |
$109,240.00 |
|
Direct Costs of Sales |
||||||
Individual Customers |
$240.00 |
$440.00 |
$640.00 |
$840.00 |
$1,040.00 |
|
Business Organizations |
$2,100.00 |
$2,300.00 |
$2,500.00 |
$2,700.00 |
$200.00 |
|
Subtotal Direct costs of Sales |
$2,340.00 |
$2,740.00 |
$3,140.00 |
3,540.00 |
$1,240.00 |
|
Marketing Expense Budget Advertising |
$600.00 |
$600.00 |
$600.00 |
$600.00 |
$500.00 |
|
Other |
$400.00 |
$400.00 |
$400.00 |
$200.00 |
$200.00 |
|
Total Sales & Marketing Expense |
$1,000.00 |
$1,000.00 |
$1,000.00 |
$800.00 |
$7.00 |
|
Marketing Budget % of Sales |
1.58% |
1.34% |
1.16% |
0.82% |
0.64% |
Annual Percentage increase is the last value is (( last value of observation - first value) / first value of observation * 100 )/ no. of observations
Keeping in mind above formula lets calculate % annual increase for all the parameters .
Sales forcast :
Individual customer : 7140- 1140 / 1140 = (6000 / 1140 )*100/4 = 131.57 % Annual Increase . Similarly ,
Business Organisation : 16.13%
Total : 18.18%
Direct Cost of Sales :
Individual Customer : 83.33%
Business Organisation : -22.69%
Marketing Expense Budget Advertising : - 4.16%
other : -12.5%
Total Sales & Marketing Expense : -7.5%
Marketing Budget % of sales : -14.87%
Get Answers For Free
Most questions answered within 1 hours.