Make a sample Forecasting table like the one below but with a budget of 3million dollars for
Fantastic news! We've Found the answer you've been seeking!
Question:
Make a sample Forecasting table like the one below but with a budget of 3million dollars for a cleaning liquid company, provide equations on how to come up with each estimate for the 3million. Details pertaining why and how much is put into everything
Profit Projections | ||||||
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 | $3,512,712.00 | |
Plant Maint. | $150,000.00 | $154,500.00 | $159,135.00 | $163,909.05 | $168,826.32 | |
Salaries/FT (10) | $550,000.00 | $550,000.00 | $566,500.00 | $583,495.00 | $600,999.85 | |
Salaries/PT (50) | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 | |
Benefits/fringe (.40) | $260,000.00 | $260,000.00 | $266,600.00 | $273,398.00 | $280,399.94 | |
IT | $225,000.00 | $236,250.00 | $248,062.50 | $260,465.63 | $273,488.91 | |
Rent | $400,000.00 | $400,000.00 | $400,000.00 | $400,000.00 | $400,000.00 | |
Insurance | $100,000.00 | $103,000.00 | $106,090.00 | $109,272.70 | $112,550.88 | |
Compliance | $20,000.00 | $20,000.00 | $20,000.00 | $20,000.00 | $20,000.00 | |
Admin. Salaries | $280,000.00 | $294,000.00 | $308,700.00 | $324,135.00 | $340,341.75 | |
Subtotal | $2,085,000.00 | $2,216,000.00 | $2,409,625.00 | $2,628,991.25 | $2,877,655.94 | |
Profit/loss | ($85,000.00) | ($156,000.00) | ($318,725.00) | ($287,183.25) | $635,056.06 | |
Assumptions | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Revenue | 0 | 3% increase | 15% increase | 12% increase | 50% increase | |
Plant 4 | ||||||
Salaries FT | 0 | 0 | 3% increase | 3% increase | 3% increase | |
Salaries PT | ||||||
Benefits/fringe (.40) | ||||||
IT | ||||||
Rent | ||||||
Insurance | ||||||
Compliance | ||||||
Admin. Salaries | ||||||
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-1259565403
5th edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date: