I have to come up with forecasting projections. These are my numbers so far. This is for
Fantastic news! We've Found the answer you've been seeking!
Question:
I have to come up with forecasting projections. These are my numbers so far. This is for make believe company. I have no idea what's next help,
Profit /loss Projection | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Revenue | $2,000,000.00 | $2,060,000.00 | $2,090,900.00 | $2,341,808.00 | $2,500,000.00 | |
Plant Maint. | $100,000.00 | $103,000.00 | $106,090.00 | $109,272.70 | $112,550.88 | |
Salaries/FT(5) | $220,000.00 | $230,000.00 | $236,900.00 | $244,007.00 | $251,327.21 | |
Salaries/PT (2) | $100,000.00 | $45,000.00 | $55,000.00 | $65,000.00 | $75,000.00 | |
Benefits/fringe (.40) | $200,000.00 | $110,000.00 | $116,760.00 | $123,602.80 | $130,530.88 | |
IT | $125,000.00 | $131,250.00 | $137,812.50 | $144,703.13 | $151,938.28 | |
Rent | $180,000.00 | $180,000.00 | $180,000.00 | $180,000.00 | $180,000.00 | |
Insurance | $75,000.00 | $75,000.00 | $75,000.00 | $75,000.00 | $75,000.00 | |
Compliance | $75,000.00 | $75,000.00 | $75,000.00 | $75,000.00 | $75,000.00 | |
Admin. Salaries | $250,000.00 | $260,000.00 | $270,000.00 | $280,000.00 | $290,000.00 | |
Subtotal | $1,325,000.00 | $2,216,000.00 | $2,409,625.00 | $2,628,991.25 | $2,877,655.94 | |
Profit/loss | $675,000.00 | ($156,000.00) | ($318,725.00) | ($287,183.25) | ($377,655.94) | |
Assumptions | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Revenue | 3% increase | 15% increase | 12% increase | 50% increase | ||
Plant 4 | ||||||
Salaries FT | 0 | 0 | 3% incease | 3% incease | 3% incease | |
Salaries PT | ||||||
Benefits/fringe (.40) | ||||||
IT | ||||||
Rent | ||||||
Insurance | ||||||
Compliance | ||||||
Admin. Salaries | ||||||
Related Book For
Statistics For The Behavioral Sciences
ISBN: 9781111830991
9th Edition
Authors: Frederick J Gravetter, Larry B. Wallnau
Posted Date: