Question

In: Finance

Spring Fish Fine Foods has $1,830,000 for capital investments this year and is considering two potential...

Spring Fish Fine Foods has $1,830,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the store's deli section for additional food service. The estimated after-tax cash flow of this project is $600,000 per year for the next five years. Project 2 is updating the store's wine section. The estimated annual after-tax cash flow for this project is $510,000 for the next six years. If the appropriate discount rate for the deli expansion is 9.4% and the appropriate discount rate for the wine section is 9.0%, use the NPV to determine which project Singing Fish should choose for the store. Adjust the NPV for unequal annual annuity.

a) If the appropriate discount rate for the deli expansion is 9.4%, what is the NPV of the deli expansion?

b) If the appropriate discount rate for the wine section is 9.0%, what is the NPV of the wine section?

c) What is the adjusted NPV equivalent annual annuity of the deli expansion?

d) What is the adjusted NPV equivalent annual annuity of the wine section?

Solutions

Expert Solution

First, we build the cash flow schedule as below:

Year cash flow -Project 1 cash flow -Project 2
0 ($1,830,000) ($1,830,000)
1 $600,000 $510,000
2 $600,000 $510,000
3 $600,000 $510,000
4 $600,000 $510,000
5 $600,000 $510,000
6 $510,000

(a) NPV of Project 1 is calculated using the NPV function in Excel with these inputs :

rate = 9.4%

values = array of cells with the cash flows

NPV = $438,546

(b)

NPV of Project 2 is calculated using the NPV function in Excel with these inputs :

rate = 9%

values = array of cells with the cash flows

NPV = $420,017

(c) adjusted NPV equivalent annual annuity = (r * NPV) / (1 - (1 + r)^-n)

where r = discount rate

n = project life

adjusted NPV equivalent annual annuity of the deli expansion = (0.094 * 438,546) / (1 - (1 + 0.094)^-5)

adjusted NPV equivalent annual annuity of the deli expansion = $113,919

(d)

adjusted NPV equivalent annual annuity = (r * NPV) / (1 - (1 + r)^-n)

where r = discount rate

n = project life

adjusted NPV equivalent annual annuity of the wine expansion = (0.09 * 420,017) / (1 - (1 + 0.09)^-6)

adjusted NPV equivalent annual annuity of the wine expansion = $93,630


Related Solutions

Singing Fish Fine Foods has ​$2,080,000 for capital investments this year and is considering two potential...
Singing Fish Fine Foods has ​$2,080,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is ​$580,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is ​$480,000 for the next six years. The appropriate discount rate for the deli...
Singing Fish Fine Foods has $1,910,000 for capital investments this year and is considering two potential...
Singing Fish Fine Foods has $1,910,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is $610,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is $530,000 for the next six years. If the appropriate discount rate for the...
Singing Fish Fine Foods has ​$2,020,000 for capital investments this year and is considering two potential...
Singing Fish Fine Foods has ​$2,020,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is ​$570,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is ​$490,000 for the next six years. If the appropriate discount rate for the...
MIRR unequal lives. Singing Fish Fine Foods has $1,860,000 for capital investments this year and is...
MIRR unequal lives. Singing Fish Fine Foods has $1,860,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is ​$620,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is $530,000 for the next six years. The appropriate discount rate...
NPV unequal lives. Singing Fish Fine Foods has ​$2,030,000 for capital investments this year and is...
NPV unequal lives. Singing Fish Fine Foods has ​$2,030,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is ​$620,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is ​$480,000 for the next six years. If the appropriate discount...
MIRR unequal lives. Singing Fish Fine Foods has $2,070,000 for capital investments this year and is...
MIRR unequal lives. Singing Fish Fine Foods has $2,070,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is $600,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is $500,000 for the next six years. The appropriate discount rate...
MIRR unequal lives. Singing Fish Fine Foods has $1,910,000 for capital investments this year and is...
MIRR unequal lives. Singing Fish Fine Foods has $1,910,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​after-tax cash flow of this project is ​$590,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is ​$520,000 for the next six years. The appropriate discount rate for...
NPV unequal lives. Singing Fish Fine Foods has ​$1,880,000 for capital investments this year and is...
NPV unequal lives. Singing Fish Fine Foods has ​$1,880,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is $560,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is $510,000 for the next six years. If the appropriate discount...
MIRR unequal lives. Singing Fish Fine Foods has ​$2,080,000 for capital investments this year and is...
MIRR unequal lives. Singing Fish Fine Foods has ​$2,080,000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is ​$600,000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is ​$510,000 for the next six years. The appropriate discount rate...
Singing Fish Fine Foods has ​$1 comma 920 comma 000 for capital investments this year and...
Singing Fish Fine Foods has ​$1 comma 920 comma 000 for capital investments this year and is considering two potential projects for the funds. Project 1 is updating the​ store's deli section for additional food service. The estimated​ after-tax cash flow of this project is ​$580 comma 000 per year for the next five years. Project 2 is updating the​ store's wine section. The estimated annual​ after-tax cash flow for this project is ​$540 comma 000 for the next six...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT