Question

2a)Andrea, a self-employed individual, wishes to accumulate a retirement fund of $900,000. How much should she...

2a)Andrea, a self-employed individual, wishes to accumulate a retirement fund of $900,000. How much should she deposit each month into her retirement account, which pays interest at a rate of 5.5%/year compounded monthly, to reach her goal upon retirement 20 yr from now? (Round your answer to the nearest cent.)

2b)Joe secured a loan of $11,000 five years ago from a bank for use toward his college expenses. The bank charges interest at the rate of 4%/year compounded monthly on his loan. Now that he has graduated from college, Joe wishes to repay the loan by amortizing it through monthly payments over 12 yr at the same interest rate. Find the size of the monthly payments he will be required to make. (Round your answer to the nearest cent.)

Homework Answers

Answer #1

2a.

FV = $900,000

rate = 5.5%/12 = 0.46%

nper = 20*12 = 248

PV = 0

Using PMT function in excel, she should deposit $2,066 per month.

2b.

First let us calculate the amount accrued today, that is at the end of 5 years:

PV = $11,000

rate = 4% / 12 = 0.33%

nper = 5*12 = 60

PMT = $0

Using FV function in Excel, the current accrued amount is $13,431.

Now let us calculate the monthly amount to be paid

PV = $13,431

FV = $0

rate = 0.33%

nper = 12 * 12 = 144

Using PMT function in excel, he should pay $117.6 per month.

Know the answer?
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
Similar Questions
Joe secured a loan of $13,000 four years ago from a bank for use toward his...
Joe secured a loan of $13,000 four years ago from a bank for use toward his college expenses. The bank charges interest at the rate of 5%/year compounded monthly on his loan. Now that he has graduated from college, Joe wishes to repay the loan by amortizing it through monthly payments over 15 years at the same interest rate. Find the size of the monthly payments he will be required to make. (Round your answer to the nearest cent.) $...
Darla purchased a new car during a special sales promotion by the manufacturer. She secured a...
Darla purchased a new car during a special sales promotion by the manufacturer. She secured a loan from the manufacturer in the amount of $24,000 at a rate of 8%/year compounded monthly. Her bank is now charging 11.5%/year compounded monthly for new car loans. Assuming that each loan would be amortized by 36 equal monthly installments, determine the amount of interest she would have paid at the end of 3 yr for each loan. How much less will she have...
Darla purchased a new car during a special sales promotion by the manufacturer. She secured a...
Darla purchased a new car during a special sales promotion by the manufacturer. She secured a loan from the manufacturer in the amount of $25,000 at a rate of 4.5%/year compounded monthly. Her bank is now charging 6.1%/year compounded monthly for new car loans. Assuming that each loan would be amortized by 36 equal monthly installments, determine the amount of interest she would have paid at the end of 3 years for each loan. How much less will she have...
Darla purchased a new car during a special sales promotion by the manufacturer. She secured a...
Darla purchased a new car during a special sales promotion by the manufacturer. She secured a loan from the manufacturer in the amount of $19,000 at a rate of 4.1%/year compounded monthly. Her bank is now charging 6.4%/year compounded monthly for new car loans. Assuming that each loan would be amortized by 36 equal monthly installments, determine the amount of interest she would have paid at the end of 3 years for each loan. How much less will she have...
Holly Krech is planning for her retirement, so she is setting up a payout annuity with...
Holly Krech is planning for her retirement, so she is setting up a payout annuity with her bank. She wishes to receive a payout of $1,900 per month for twenty years. (a) How much money must she deposit if her money earns 7.8% interest compounded monthly? (Round your answer to the nearest cent.) (b) Find the total amount that Holly will receive from her payout annuity.
Sarah secured a bank loan of $195,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $195,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.)
Sarah secured a bank loan of $195,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $195,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.)
Sarah secured a bank loan of $195,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $195,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 5 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $
Luis has $170,000 in his retirement account at his present company. Because he is assuming a...
Luis has $170,000 in his retirement account at his present company. Because he is assuming a position with another company, Luis is planning to roll over his assets to a new account. Luis also plans to put $2500/quarter into the new account until his retirement 30 yr from now. If the account earns interest at the rate of 6%/year compounded quarterly, how much will Luis have in his account at the time of his retirement?  Hint: Use the compound interest formula...
a man wishes to save for his retirement pension plan which is 36 years from now....
a man wishes to save for his retirement pension plan which is 36 years from now. he planned to receive 100000 at the end of each year for the nest 15 years starting from the first year of his retirement. if the insurance company offers an investment of 11.495% interest rate compounded quarterly, what will be hi s quarterly payments. Please Solve As soon as Solve quickly I get you UPVOTE directly Thank's Abdul-Rahim Taysir
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • What is the regression equation for predicting Y from X? And, Calculate the predicted Y for...
    asked 42 seconds ago
  • Write a program that launches 50 threads. Each thread should add one to a variable named...
    asked 4 minutes ago
  • Write a C++ Function that finds the 4 values that are adjacent of one another (Vertical,...
    asked 6 minutes ago
  • 5.11 Suppose that each of the following Update operations is applied directly to the database state...
    asked 15 minutes ago
  • Consider the following relations for a database that keeps track of business trips of salespersons in...
    asked 30 minutes ago
  • Artificial Intelligence Question. This topic is about Heuristic search and stochastic methods. I will like it...
    asked 52 minutes ago
  • The following are programming examples in which multithreading provides better performance than a single-threaded solution: a....
    asked 1 hour ago
  • The CASE structure is a selection structure, however not all selection structures may be represented as...
    asked 1 hour ago
  • A man stands on the roof of a building of height 15.1 m and throws a...
    asked 1 hour ago
  • What is the role of benzyltrimethylammonium hydroxide in the synthesis of tetraphenylcyclopentadienone, and why is it...
    asked 1 hour ago
  • Read the following description of the MHC-PMA (Mental Health Care-Patient Management Application) then answer the questions...
    asked 1 hour ago
  • How does your worldview influence the level of apprehension or attitudes you feel when communicating with...
    asked 1 hour ago