Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want the breakeven-point and IRR Year-by-year profit and loss assumptions Year 1 Year 2 Year 3 Year Year 5 Annual cumulative price (revenue) increase

I want the breakeven-point and IRR

image text in transcribed
Year-by-year profit and loss assumptions Year 1 Year 2 Year 3 Year Year 5 Annual cumulative price (revenue) increase 2.00% 40.00% 25.00% 5.00% Annual cumulative inflation (expense) increase 2.00% 4.00% 6.00% 5.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 SO $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 8,400 Utilities 170,000 $173,400 $180,336 $191, 156 $200,714 Property taxes $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 O Other unusual expenses (income) O O Earnings before taxes ($27,993) ($27,656) $190,776 $365,436 $385,776 Taxes on income 5% 0 0 9,539 18,272 19,289 Net income (loss) $27,993) ($27,656) $181,237 $347,164 5366,487 Profit -2.30% 2.23% 11.97% 19.59% 19.71%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

Students also viewed these Economics questions