In the following ordinary annuity, the interest is compounded with each payment,

Question

In the following ordinary annuity, the interest is compounded with each payment, and the payment is made at the end of the compounding period. Find the amount of time needed for the sinking fund to reach the given accumulated amount. (Round your answer to two decimal places.) $4500 yearly at 6% to accumulate $100,000. yr 14.–/2 points BerrFinMath1 2.3.007. Ask Your Teacher My Notes Question Part Points Submissions Used In the following ordinary annuity, the interest is compounded with each payment, and the payment is made at the end of the compounding period. An individual retirement account, or IRA, earns tax-deferred interest and allows the owner to invest up to $5000 each year. Joe and Jill both will make IRA deposits for 30 years (from age 35 to 65) into stock mutual funds yielding 9.2%. Joe deposits $5000 once each year, while Jill has $96.15 (which is 5000/52) withheld from her weekly paycheck and deposited automatically. How much will each have at age 65? (Round your answer to the nearest cent.) Joe $ Jill $ Show My Work (Optional) Show Your Work Help You can submit show my work an unlimited number of times. 15.–/1 points BerrFinMath1 2.3.008. Ask Your Teacher My Notes Question Part Points Submissions Used In the following ordinary annuity, the interest is compounded with each payment, and the payment is made at the end of the compounding period. How much must you invest each month in a mutual fund yielding 13.9% compounded monthly to become a millionaire in 10 years? (Round your answer to the nearest cent.) $ Show My Work (Optional) Show Your Work Help You can submit show my work an unlimited number of times. 16.–/1 points BerrFinMath1 2.4.001. Ask Your Teacher My Notes Calculate the present value of the annuity. (Round your answer to the nearest cent.) $12,000 annually at 7% for 10 years. $ Show My Work (Optional) Show Your Work Help You can submit show my work an unlimited number of times. 17.–/1 points BerrFinMath1 2.4.003. Ask Your Teacher My Notes Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Monthly payments on $130,000 at 4% for 25 years. $ Show My Work (Optional) Show Your Work Help You can submit show my work an unlimited number of times. 18.–/1 points BerrFinMath1 2.4.004. Ask Your Teacher My Notes Question Part Points Submissions Used Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments on $18,500 at 3.8% for 6 years. $ Show My Work (Optional) Show Your Work Help You can submit show my work an unlimited number of times. 19.–/1 points BerrFinMath1 2.4.005. Ask Your Teacher My Notes Question Part Points Submissions Used Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 5 years of monthly payments on $140,000 at 4% for 25 years. $ Show My Work (Optional) Show Your Work Help

Explanation / Answer

Question 1 : Find the amount of time needed for the sinking fund to reach the given accumulated amount. (Round your answer to two decimal places.) $4500 yearly at 6% to accumulate $100,000

Answer 1 :This is obtained using nper formula in excel as in =nper(rate,pmt,pv,[fv],[type]) where rate = 0.06, pmt = 4500, fv =100000 and type = 0 (since it is at the end of the period)

Amount of time needed for the sinking fund to reach the given accumulated amount = nper(0.06,-4500,0,100000,0) = 14.54 years

Question 2: An individual retirement account, or IRA, earns tax-deferred interest and allows the owner to invest up to $5000 each year. Joe and Jill both will make IRA deposits for 30 years (from age 35 to 65) into stock mutual funds yielding 9.2%. Joe deposits $5000 once each year, while Jill has $96.15 (which is 5000/52) withheld from her weekly paycheck and deposited automatically. How much will each have at age 65?

Answer 2: Joe's value =fv(rate,nper,pmt) =fv(0.092,30,5000) = $707,487.89

Jills value with weekly investment =fv(rate,nper,pmt) where rate = 0.092/52, nper = 30*52 and pmt = 96.15. Hence Jill's value = fv(0.092/52,30*52,96.15) = $802,215.70

Question 3: How much must you invest each month in a mutual fund yielding 13.9% compounded monthly to become a millionaire in 10 years?

Answer 3: Monthly rate = 0.139/12, and number of period = nper = 10*12 =120 months, fv=1,000,000

The amount that should be invested each month =pmt(rate,nper,pv,[fv],[type]) =pmt(0.0132/12,120,0,1000000,0) = $3,883.24

Question 4: Calculate the present value of the annuity. (Round your answer to the nearest cent.) $12,000 annually at 7% for 10 years

Answer 4: Present value =pv(rate,nper,pmt) =pv(0.07,10,12000) = $84,282.98

Note: We have answered 4 full questions. Please post remaining questions separetel for experts to answer

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.