Question

Asked Nov 9, 2019

“Suppose that your parents are willing to lend you $20,000 for part of the cost of your college education and living expenses. They want you to repay them the $20,000 without any interest, in a lump sum 15 years after you graduate, when they plan to retire and move. Meanwhile, you will be busy repaying federally guaranteed loans for the first 10 years after graduation. But you realize that you won’t be able to repay the lump sum without saving up. So you decide that you will put aside money in an interest-bearing account every month for the first five years before the payment is due. You feel comfortable with setting aside $275 a month (the amount of the payment on your college loans, which will be paid off after 10 years).

How high an annual nominal rate on savings do you need to accumulate the $20,000, in 60 months, if interest is compounded monthly? Enter into a spreadsheet the values of *d = 275, *r = 0.05 (annual rate), and *n = 60*, and the savings formula with *r* replaced by *r*/12 (the monthly interest rate). You will find that the amount accumulated is not enough. Change *r* to 0.09, it’s more than enough. Try other values until you determine *r *to two decimal places.”

I entered information in Excel spreadsheet and I am trying to see if I am doing it correctly. I have never used Excel.

Step 1

**Computation:**

Tagged in

Q: New parents wish to save for their newborn's education and wish to have $46,000 at the end of 17 yea...

A: Computation of yearly payment:Hence, the yearly payment is -$1,682.02.

Q: You borrow $5000 at 10% per year and will pay off the loan in 3 equal annual payments starting one y...

A: Calculation of Payment at the end of Year 2:The interest payment is $348.94 and principal payment is...

Q: The next dividend payment by Grenier, Inc., will be $1.64 per share. The dividends are anticipated t...

A: Question 1:Calculation of Dividend Yield and Capital Gains Yield:The dividend yield is 5.29% and cap...

Q: Scenario Probability Stock fund Rate of Return Bond fund Rate of Return Severe recession 0.05 -30 ...

A: Computation of variance and standard deviation of stock fund:

Q: What would the average tax rate for a person who paid taxes of $6,435 on taxable income of $40,780?

A: Calculation of average tax rate:Answer: Average tax rate is 15.78%Meaning: Average tax rate is calcu...

Q: Is there an easily identifiable debt-equity ratio that will maximize the value of a firm? Why or why...

A: The value of the firm is dependent upon the future cash flows and the discount rate. In the absence ...

Q: Compute Bowling Avenue Inc.'s required rate of return given a beta of.9, risk free rate of 3.25%, an...

A: Calculation of required rate of return:Answer:The required rate of return is 8.425%

Q: Fran Powers created following budget and reported actual spending listed. Calculate the variance for...

A: Variance:The variance can be defined as the anticipation of the squared unconventionality of a rando...

Q: You own $25,080 of Human Genome stock that has a beta of 3.72. You also own $13,376 of Frozen Food E...

A: To determine the portfolio beta we first need to calculate the weights of each investment.