Question

4. In a previous homework, we learned that skipping your daily Starbucks fix would save you S180 per month. If you invested those savings in a retirement account earning 0.25% per month compound interest, you would have an additional S166,691 saved up by time you retire. Assuming you will live 20 years after retiring, how much additional monthly income will this provide you in your retirement?

66 A concept car that will get 100 miles per gallon and carry four persons would have a carbon-fiber and aluminum composite frame with a 900 cc three-cylinder turbodiesel/electric hybrid power plant. The extra cost of these technologies is esti- mated to be $11,000. (a) If gasoline savings over a comparable conventional car would be $900 in year one, increasing by 10% each year, what is the present worth of the savings over a 10-year period at an interest rate of 8% per year? (b) Compare the present worth values to determine if the extra cost is recovered by fuel savings

0 0
Add a comment Improve this question Transcribed image text
Answer #1

(a) Present worth (PW) of savings is computed as follows. Note that

Saving in year N = savings in year (N - 1) x 1.10

PV Factor in year N = (1.08)-N

Year Savings ($) PV Factor @8% Discounted Savings ($)
(A) (B) (A) x (B)
1 900.00 0.9259 833.33
2 990.00 0.8573 848.77
3 1089.00 0.7938 864.48
4 1197.90 0.7350 880.49
5 1317.69 0.6806 896.80
6 1449.46 0.6302 913.41
7 1594.40 0.5835 930.32
8 1753.85 0.5403 947.55
9 1929.23 0.5002 965.10
10 2122.15 0.4632 982.97
PW of Savings ($) = 9063.21

(b) Since PW of savings is less than the PW of extra cost ($9063.21 < $11000), extra cost is not recovered by savings.

[Screenshot follows:

E 284 PW - Microsoft Excel Home nsert Page Layout Data Review Vie novaP Cut Calibri Wrap Text General E Copy Paste Merge & Center % , ta:: Conditional Format Cell Inser Formatting as Table Styles Clipboard Font Alignment Number Styles C13 f PW of Savings (S)- Savings ($) Discounted Savings ($) (A) x (B) 1 Year PV Factor @8% 1.08)A(-A3) 1.08)A(-A4) 1.08)A(-A5) 900 B3*1.1 -B4*1.1 B5*1.1 B6*1.1 B7*1.1 -B8*1.1 B9*1.1 B10*1.1 B11*1.1 B3* C3 B4*C4 B5*C5 B6*C6 B7* C7 B8* C8 B9*C9 B10*C10 B11*C11 B12* C12 1.08)A(-A7) 10 8 11 9 12 10 13 14 15 16 1.08)A(-A9) 1.08)A(-A10) 1.08)A(-A11) 1.08)A(-A12) PW of Savings (S) SUM(D3:D12) H Sheet1 Sheet2 Sheet3 Ready

Add a comment
Know the answer?
Add Answer to:
4. In a previous homework, we learned that skipping your daily Starbucks fix would save you...
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
  • 64 2.06 A concept car that will get 100 miles per gallon and carry four persons...

    64 2.06 A concept car that will get 100 miles per gallon and carry four persons would have a carbon-fiber and aluminum composite frame with a 900 cc three-cylinder turbodiesel/electric hybrid power plant. The extra cost of these technologies is esti- mated to be $11,000. (a) If gasoline savings over a $900 in year one, increasing by 10% each year, what is the present worth of the savings over a 10-year period at an interest rate of 8% per year?...

  • 4. In a previous homework, we learned that skipping your daily Starbucks fix would save you...

    4. In a previous homework, we learned that skipping your daily Starbucks fix would save you $180 per month. If you invested those savings in a retirement account earning 0.25% per month compound interest, you would have an additional S166,691 saved up by time you retire. Assuming you will live 20 years after retiring, how much additional monthly income will this provide you in your retirement?

  • skipping your daily Starbucks fix would save you $180 per month. If you invested those savings...

    skipping your daily Starbucks fix would save you $180 per month. If you invested those savings in a retirement account earning 0.25% per month compound interest, you would have an additional $166,691 saved up by time you retire. Assuming you will live 20 years after retiring, how much additional monthly income will this provide you in your retirement

  • 4. A concept car that will get 100 miles per gallon and carry 4 persons would...

    4. A concept car that will get 100 miles per gallon and carry 4 persons would have a carbon-fiber and aluminium composite frame with a 900 cc three cylinder turbodiesel/electric hybrid power plant. The extra cost of these technologies is estimated to be $11,000. If gasoline savings over a comparable conventional car would be $900 in year 1, increasing by 10% each year, what is the present worth of the savings over a 10-year period at an interest rate of...

  • 1. Valley Rendering, Inc. is considering purchasing a new flotation system for recovering more grease. The...

    1. Valley Rendering, Inc. is considering purchasing a new flotation system for recovering more grease. The company can finance a $150,000 system at 5% per year compound interest or 5.5% per year simple interest. If the total amount owed is due in a single payment at the end of 3 years, (a) which interest rate should the company select, and (b) how much is the difference in interest between the two schemes? (ANSWER: (b) $1106.) 2. A mechanical consulting company...

  • Question 8 Not yet answered Marked out of 1 You would like to save up for...

    Question 8 Not yet answered Marked out of 1 You would like to save up for a deposit of $30,000 to buy a home in exactly 9 years. You can invest your savings at an interest rate of 4.3% per year (compounded yearly) Calculate the amount that you must save at the end of each year for the next 9 years to have enough savings for this deposit. Your answer should be to the nearestdollar and you should not include...

  • Question 8 Not yet answered Marked out of 1 You would like to save up for...

    Question 8 Not yet answered Marked out of 1 You would like to save up for a deposit of $30,000 to buy a home in exactly 9 years. You can invest your savings at an interest rate of 4.3% per year (compounded yearly) Calculate the amount that you must save at the end of each year for the next 9 years to have enough savings for this deposit. Your answer should be to the nearestdollar and you should not include...

  • 4-1 Rose recently graduated in engineering. Her 5 employer will give her a raise of $6500...

    4-1 Rose recently graduated in engineering. Her 5 employer will give her a raise of $6500 per year if she passes the FE exam (Fundamentals of Engineering) (a) Over a career of 45 years, what is the present worth of the raise if the interest rate is 4%? (b) What is the future worth at Year 45? (c) Incentive pay systems can create ethical dilem- mas in the workplace. Describe one each from the perspective of the employer and the...

  • Use what you have learned about the time value of money to analyze each of the...

    Use what you have learned about the time value of money to analyze each of the following decisions: Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants to give you generous gift. She wants you to choose which one of the following sets of cash flows you would like to receive: Option A: Receive a one-time gift of $10,000 today. Option B: Receive a $1600 gift each year for the next 10 years....

  • 4-6 A man buys a ear for $18,000 with no money down. He pays for the...

    4-6 A man buys a ear for $18,000 with no money down. He pays for the car in 30 equal monthly pay- ments with interest at 12% per annum, compounded monthly. What is his monthly loan payment? 4-1 Rose recently graduated in engineering. Her employer will give her a raise of $6500 per year if she passes the FE exam (Fundamentals of Engineering). (a) Over a career of 45 years, what is the present worth of the raise ifthe interest...

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