Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the IRR and breakeven-point in depth with calculation Year-by-year profit and loss assumptions Year Year 2 Year 3 Year 4 Year ! Annual cumulative

Calculate the IRR and breakeven-point in depth with calculation

image text in transcribed
Year-by-year profit and loss assumptions Year Year 2 Year 3 Year 4 Year ! Annual cumulative price (revenue) increase 2.00% 40.00% 25.00% 5.00% Annual cumulative inflation (expense) increase 2.00% 4.00% 6.00% .00% Interest rate on ending cash balance 0.00% 0.00% 0.00% 0.00% 0.00% Year 1 Year 2 Year 3 Year 4 Year 5 Revenue Gross revenue $1, 187,500 $1,211,250 $1,695,750 $2, 119,688 $2,225,672 Cost of goods sold (manufacturing cost) 593,750 605, 625 847,875 1,059,844 1, 112,836 Gross margin $593,750 $605,625 $847,875 $1,059,844 $1, 112,836 Other revenue [source] $0 $0 $0 $0 $0 Interest income $0 $0 $0 $0 Total revenue $593,750 $605,625 $847,875 $1,059,844 $1,112,836 Operating expenses Sales and marketing $120,000 $122,400 $127,296 $134,934 $141,680 Payroll and payroll taxes (salaries) 30,000 $30,600 $31,824 $33,733 $35,420 Depreciation 20,000 20,000 20,000 20,000 20,000 Insurance 1,500 $1,530 $1.591 $1,687 $1,771 Maintenance, repair, and overhaul 8,000 8, 160 8,320 8,480 3,400 Utilities 170,000 $173,400 $180,336 $191, 156 $200,714 Property taxes $0 $0 $0 $0 Administrative fees 95,000 $96,900 $100,776 $106,823 $112, 164 Space Rental + Other 175,000 $178,500 $185,640 $196,778 $206,617 Total operating expenses $619,500 $631,490 $655,783 $693,591 $726,767 Operating income ($25,750) ($25,865) $192,092 $366,253 $386,069 Interest expense on long-term debt 2,243 1,791 1,316 817 293 Operating income before other items ($27,993) ($27,656) $190,776 $365,436 $385,776 Loss (gain) on sale of assets 0 OO o O Other unusual expenses (income) 0 0 Earnings before taxes ($27,993) ($27,656) $190,776 $365,436 $385,776 Taxes on income 5% 0 ,539 18,272 19,289 Net income (loss) ($27,993) ($27,656) $181,237 $347, 164 $366,487 Profit 2.30% 2.23% 1.97% 9.59% 9.71%

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

Step: 3

blur-text-image

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

Understanding Econometrics With Economic Applications

Authors: Dennis Halcoussis

1st Edition

0030348064, 9780030348068

More Books

Students also viewed these Economics questions

Question

Dont smell (i.e., too much perfume/cologne).

Answered: 1 week ago