What is the value of the ira

Reference no: EM131814002

Question: 1. Ms. Manifee would like to purchase a new condo for $105,000. She plans to make a down payment of $50,000 and to borrow the rest of the money from the bank. The bank charges an annual percentage rate of 4% compounded daily. She agrees to monthly payments to pay off the loan in 10 years.

a) Write or copy from an Excel table the amount of interest paid each month, the amount that is paid on the principal each month, and the balance remaining at the end of each month. You only need to copy the Excel table for the first 2 years of the 10-year loan. Please do not attach the Excel file as a separate file in your homework submission.

b) Assume Ms. Manifee has made 14 payments and would like to pay off the balance immediately after the 14th payment. Write down the equation or Excel formula that enables you to calculate this balance. The formula should not be recursive.

2. An individual retirement account (IRA) offers a risk-free option with a nominal 5% interest rate, compounded monthly. You get paid two times per month (the 1st and the 15th of the month) and decide to invest $500 per pay period into the IRA. This is a situation where the payment periods occur more frequently than the compounding periods.

a) First assume that interest is calculated only at the end of the month so that $500 invested at the beginning of the month earns the same amount of interest as $500 invested in the middle of the month. In other words, there is no benefit to invest $500 in the middle of the month versus the end of the month. With this assumption, what is the value of the IRA after 10 years?

b) Now assume that a deposit starts to earn interest whenever the deposit is made, so that there are 0.5 interest periods per payment period. With this assumption, what is the value of the IRA after 10 years?

c) Does the assumption in part a or part b earn more money? Why does this result make intuitive sense?

Reference no: EM131814002

Questions Cloud

Compute the predetermined overhead rate : At the end of 2011, records show the company incurred $789,080 of actual overhead costs. Determine the predetermined overhead rate for year 2011

Discuss variances management considers important : Management by exception focuses only on those variances management considers important

How much is excluded from taxation : Mr. and Mrs. Ybarra, a retired couple in their late 70s, come in to meet with you. They are very friendly and living a comfortable retirement due.

Explain what is meant by opportunity cost : Analyze the concept of opportunity cost. Explain what is meant by opportunity cost. Explain how opportunity cost relates to the definition of economics.

What is the value of the ira : First assume that interest is calculated only at the end of the month so that $500 invested at the beginning of the month earns the same amount of interest.

Discuss the health risks associated with acute exposure : How would training at medium altitude and then competing at altitude affect a runner's performance?How would training at sea level affect a runners performance?

Prepare the journal entries to record this transaction : the company learns that its receivable from Megan Gray is not collectible, and management authorizes

How much liability for outstanding premiums should recorded : Crispy Frosted Flakes Company offers its customers a pottery cereal bowl if they send in 4 boxtops from Crispy Frosted Flakes boxes and $1.

What elements of medicare would you retain : What would it look like? What elements of Medicare would you retain?

User Account

All Pages