Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Profit / loss Projection Year 1 Year 2 Year 3 Year 4 Year 5 Revenue $ 2 , 0 0 0 , 0 0 0

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 003% incease 3% incease 3% incease
Salaries PT
Benefits/fringe (.40)
IT
Rent
Insurance
Compliance
Admin. Salaries

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fixed Income Securities Tools For Todays Markets

Authors: Bruce Tuckman, Angel Serrat

3rd Edition

0470891696, 978-0470891698

More Books

Students explore these related Finance questions