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

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 ProjectionYear 1Year 2Year 3Year 4Year 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  
        
AssumptionsYear 1Year 2Year 3Year 4Year 5 
Revenue03% increase15% increase12% increase50% increase 
Plant 4      
Salaries FT003% increase3% increase3% increase 
Salaries PT      
Benefits/fringe (.40)      
IT      
Rent      
Insurance      
Compliance      
Admin. Salaries      
      

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ProfitLoss Projection table for a cleaning liquid company with a budget of 3 million for each year The table includes equations for each estimate Prof... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!