Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to find the IRR of this table by using the function in excel. I keep getting an error. 0 1 2 3 4

I need to find the IRR of this table by using the function in excel. I keep getting an error.

0 1 2 3 4 5 20xx 20xx 20xx 20xx 20xx 20xx Investment Outlays at Time Zero: Equipment or other investment (10,000) Operating Cash Flows over the Project's Life: Sales revenue 32,048 30,258 28,195 19,369 17,589 Cost of Sales 27,125 25,987 17,320 10,257 8,140 Gross Profit 4,923 4,271 10,875 9,112 9,449 Adverstiing 3,000 2,500 1,000 1,000 1,000 Depreciation (equipment) 5,625 5,625 5,625 5,625 5,625 Dues and subscriptions - - - - - Insurance 1,200 1,200 1,200 1,200 1,200 Salaries 38,400 38,400 38,400 38,400 38,400 Payroll Taxes 1 1 1 1 1 Other Taxes 1,563 150 (2,465) 3,856 2,431 Other expenses - - - - - Total expenses 49,789 47,876 43,761 50,082 48,657 Oper. income before taxes (EBIT) (44,866) (43,605) (32,886) (40,970) (39,208) Taxes on operating income (1,346) (1,308) (987) (1,229) (1,176) Net Operating Profit After Taxes (NOPAT) (43,520) (42,297) (31,899) (39,741) (38,032) Add back depreciation 5,625 5,625 5,625 5,625 5,625 Operating cash flow ($37,895) ($36,672) ($26,274) ($34,116) ($32,407) Terminal Year Cash Flows: After-tax salvage value of equipment that you sell 1 Total termination cash flows $1 Net Cash Flow (Time line of cash flows) ($10,000) ($37,895) ($36,672) ($26,274) ($34,116) ($32,406)

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

Accounting

Authors: Lew Edwards, John Medlin, Keryn Chalmers, Andreas Hellmann, Claire Beattie, Jodie Maxfield, John Hoggett

9th edition

1118608224, 1118608227, 730323994, 9780730323990, 730319172, 9780730319177, 978-1118608227

More Books

Students also viewed these Accounting questions

Question

When is stress positive? Give examples.

Answered: 1 week ago

Question

Values: What is important to me?

Answered: 1 week ago