Question

Develop a spreadsheet to determine the next present value or present worth of the following proje...

Develop a spreadsheet to determine the next present value or present worth of the following project:
Investment: 170,000
Revenue/Savings: 32,000
Incremental Expense/Cost: 6,000
Salvage Value: 20,000
Project Life: 10 years
MACRS Schedule: 7 years
Tax Rate: 24%
MARR: 12%
Inflation: 3%
Complete this on the basis of a real dollars basis rather than actual dollars.
Is this a good investment to make?

Year Percent
1 14.29%
2 24.49%
3 17.49%
4 12.49%
5 8.93%
6 8.92%
7 8.93%
8 4.46%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer: -

According to question there are following data are given,

Investment: 170,000

Revenue/Savings: 32,000

Incremental Expense/Cost: 6,000

Salvage Value: 20,000

Project Life: 10 years

MACRS Schedule: 7 years

Tax Rate: 24%

MARR: 12%

Inflation: 3%


E-D A F=B-C-E G=F24% | Tax @ 24% Net Income Year Investment YO Y1 Y2 Revenue Expense MACRS Depreciation (170,000.00) 24,293.

Add a comment
Know the answer?
Add Answer to:
Develop a spreadsheet to determine the next present value or present worth of the following proje...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A project requires $414073 of equipment that is classified as 7-year property. What is the book...

    A project requires $414073 of equipment that is classified as 7-year property. What is the book value of this asset at the end of year 3 given the following MACRS depreciation allowances, starting with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, and 4.46 percent?

  • ABC Company purchased $50701 of equipment 4 years ago. The equipment is 7-year MACRS property. The...

    ABC Company purchased $50701 of equipment 4 years ago. The equipment is 7-year MACRS property. The firm is selling this equipment today for $4916. What is the After-tax Salvage Value if the tax rate is 20%? The MACRS allowance percentages are as follows, commencing with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, and 4.46 percent.

  • A project requires $37,655 of equipment that is classified as a 7-year property. What is the...

    A project requires $37,655 of equipment that is classified as a 7-year property. What is the depreciation expense in Year 5 given the following MACRS depreciation allowances, starting with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, and 4.46 percent? Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box.

  • A project requires $72,645 of equipment that is classified as a 7-year property. What is the...

    A project requires $72,645 of equipment that is classified as a 7-year property. What is the depreciation expense in Year 5 given the following MACRS depreciation allowances, starting with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, and 4.46 percent? Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box.

  • Problem 10-8 Calculating Salvage Value [LO1] An asset used in a four-year project falls in the...

    Problem 10-8 Calculating Salvage Value [LO1] An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $6,050,000 and will be sold for $1,250,000 at the end of the project. If the tax rate is 35 percent, what is the aftertax salvage value of the asset? Refer to Table 10.7. (Enter your answer in dollars, not millions of dollars, i.e. 1,234,567.) Aftertax salvage value Property Class Year Three-Year...

  • An asset used in a four-year project falls in the five-year MACRS class for tax purposes....

    An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $6,150,000 and will be sold for $1,350,000 at the end of the project. If the tax rate is 34 percent, what is the aftertax salvage value of the asset? (Enter your answer in dollars, not millions of dollars, i.e. 1,234,567.) Refer to Table below: Year                Three-Year               Five-Year                   Seven-Year 1                        33.33%                     20.00%                     14.29% 2                        44.45                         32.00                         24.49 3                        14.81                         19.20                         17.49 4                         7.41                           11.52                        12.49 5                                                            11.52                         8.93 6                                                             5.76                           8.92 7                                                                                                8.93 8                                                                                                4.46

  • A proposed cost-saving device has an installed cost of $760,000. The device will be used in...

    A proposed cost-saving device has an installed cost of $760,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. The required initial net working capital investment is $65,000, the tax rate is 25 percent, and the project discount rate is 8 percent. The device has an estimated Year 5 salvage value of $100,000. What level of pretax cost savings do we require for this project to be profitable? MACRS schedule...

  • A project requires $471428 of equipment that is classified as 7-year property. What is the depreciation...

    A project requires $471428 of equipment that is classified as 7-year property. What is the depreciation expense in Year 5 given the following MACRS depreciation allowances, starting with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, and 4.46 percent? Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box. For example, if your answer is $12.345 then enter as 12.35 in the answer box.

  • CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...

    CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $401,000 is estimated to result in $147,000 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table) and it will have a salvage value at the end of the project of $48,000. The press also requires an initial investment in spare parts inventory of $15,300, along with an additional $2,300 in inventory for each succeeding year...

  • CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...

    CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $419,000 is estimated to result in $156,000 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table) and it will have a salvage value at the end of the project of $57,000. The press also requires an initial investment in spare parts inventory of $16,200, along with an additional $3,200 in inventory for each succeeding year...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT