Question

In: Economics

  An upgrade to a compressor costs $30,000 and results in the following net revenues (income minus...

  An upgrade to a compressor costs $30,000 and results in the following net revenues (income minus expenses).

Year      Net Revenue

1             $13,000

2               12,000

3               10,500

4                9,000

5                8,200

       Determine the internal rate of return.

Solutions

Expert Solution

As per the information provided in the question the upgradation of computer cost is $30000,

so the cash flow in period 0 is -$30000

the net revenue are given below upto year 5

Years Cash flow PVF@20% PV of Cashflow PVF@25% PV of Cashflow
0 -30000 1 -30000 1 -30000
1 13000 0.8333 10832.9 0.8000 10400
2 12000 0.6944 8332.8 0.6400 7680
3 10500 0.5787 6076.35 0.5120 5376
4 9000 0.4823 4340.7 0.4096 3686.4
5 8200 0.4019 3295.58 0.3277 2687.14
NPV at 20%= 2878.33 NPV at 25%= -170.46

Internal Rate of return (IRR) is the interest at which the NPV=0, to estimate it we have followed trial and error method, first we have taken the PV factor = 20%, where the NPV =$2878.33, which is positive and then we have taken the PV factor = 25%, where the NPV = -$170.46, which is negative. So the Rate of return must fall in between 20% to 25%.

Therefore

R1 = 20%              NPV1=$2878.33

R2= 25%               NPV2= -$170.46

Using linear interpolation method of estimation of Internal Rate of Return (IRR)

IRR= R1 + (R2-R1)X[NPV1/(NPV1-NPV2)]

IRR = 20 + (25-20)[(2878.33)/ {2878.33-(-170.46)}]

IRR = 20 + (5)[(2878.33)/(2878.33+170.46)]

IRR = 20 + 5(2878.33/ 3048.79)

IRR = 20 + 5(0.944089)

IRR = 20 + 4.72

IRR = 24.72%

The internal rate of return (IRR) is 24.72%


Related Solutions

The Talley Corporation had taxable operating income of $385,000 (i.e., earnings from operating revenues minus all operating costs).
Corporate Tax LiabilityThe Talley Corporation had taxable operating income of $385,000 (i.e., earnings from operating revenues minus all operating costs). Talley also had (1) interest charges of $60,000, (2) dividends received of $25,000, and (3) dividends paid of $40,000. Its federal tax rate was 21% (ignore any possible state corporate taxes). Recall that 50% of dividends received are tax exempt.What is the firm’s taxable income? Round your answer to the nearest dollar.$  What is the tax expense? Round your answers to...
The beginning balance of retained earnings plus net income (revenues less expenses), less dividends results in...
The beginning balance of retained earnings plus net income (revenues less expenses), less dividends results in the ending balance of retained earnings. At September 1, 2014, Five-O Inc. reported retained earnings of $136,000. During the month, Five-O generated revenues of $20,000, incurred expenses of $12,000, purchased equipment for $5,000 and paid dividends of $2,000. What is the balance in retained earnings at September 30, 2014? $8,000 credit $137,000 credit $142,000 credit $136,000 debit
Revenues = 1,080; Costs = 306; Tax rate = 0.26; Interest Expense = 51; Net Income...
Revenues = 1,080; Costs = 306; Tax rate = 0.26; Interest Expense = 51; Net Income = 288; What is the amount of Depreciation? Enter value to the nearest penny.
A company's income statement showed the following: net income, $124,000; depreciation expense, $30,000; and gain on...
A company's income statement showed the following: net income, $124,000; depreciation expense, $30,000; and gain on sale of plant assets, $14,000. An examination of the company's current assets and current liabilities showed the following changes as a result of operating activities: accounts receivable decreased $9,400; merchandise inventory increased $18,000; prepaid expenses decreased $6,200; accounts payable increased $3,400. Calculate the net cash provided or used by operating activities. Select one: a. $155,000. b. $145,800. c. $141,000. d. $139,000. Please Solve As...
Based on the following transactions, calculate the revenues, expenses, and net income that would be reported...
Based on the following transactions, calculate the revenues, expenses, and net income that would be reported on (a) the cash basis and (b) the accrual basis: i. Inventory costing $70,000 was purchased on account. ii. Inventory costing $60,000 was sold for $100,000. Eighty percent of the sales were for cash. iii. Cash collected from credit customers (those who bought on account) totalled $20,000. iv. A lease was signed at the beginning of the year, requiring monthly payments of $1,000. The...
1. Based on the following transactions, calculate the revenues, expenses, and net income that would be...
1. Based on the following transactions, calculate the revenues, expenses, and net income that would be reported on (a) the cash basis and (b) the accrual basis: i. Inventory costing $70,000 was purchased on account. ii. Inventory costing $60,000 was sold for $100,000. Eighty percent of the sales were for cash. iii. Cash collected from credit customers (those who bought on account) totalled $20,000. iv. A lease was signed at the beginning of the year, requiring monthly payments of $1,000....
Based on the following transactions, calculate the revenues, expenses, and net income that would be reported...
Based on the following transactions, calculate the revenues, expenses, and net income that would be reported on (a) the cash basis and (b) the accrual basis: i. Inventory costing $70,000 was purchased on account. ii. Inventory costing $60,000 was sold for $100,000. 80% of the sales were for cash. iii. Cash collected from credit customers (those who bought on account) totalled $20,000. iv. A lease was signed at the beginning of the year, requiring monthly payments of $1,000. The rent...
What is the correct presentation of the income statement? Revenues - expenses = Net income -...
What is the correct presentation of the income statement? Revenues - expenses = Net income - losses + gains Revenues - expenses + gains - losses = Net Income Revenues + gains - losses - expenses = Net Income Revenues - losses - expenses + gains = Net Income Which statement about negative goodwill is true? Negative goodwill should be recorded as a direct credit to retained earnings. Negative goodwill is not recorded. Negative goodwill should be allocated proportionately to...
The Talley Corporation had taxable operating income of $395,000 (i.e., earnings from operating revenues minus all...
The Talley Corporation had taxable operating income of $395,000 (i.e., earnings from operating revenues minus all operating costs). Talley also had (1) interest charges of $40,000, (2) dividends received of $10,000, and (3) dividends paid of $20,000. Its federal tax rate was 21% (ignore any possible state corporate taxes). Recall that 50% of dividends received are tax exempt. What is the firm’s taxable income? Round your answer to the nearest dollar. $ What is the tax expense? Round your answers...
The Talley Corporation had taxable operating income of $490,000 (i.e., earnings from operating revenues minus all...
The Talley Corporation had taxable operating income of $490,000 (i.e., earnings from operating revenues minus all operating costs). Talley also had (1) interest charges of $70,000, (2) dividends received of $25,000, and (3) dividends paid of $40,000. Its federal tax rate was 21% (ignore any possible state corporate taxes). Recall that 50% of dividends received are tax exempt. What is the after-tax income? Round your answers to the nearest dollar.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT