Can you fill in the tables and answer the questions?I would appreciate it If you could also explain how to plug this into a financial calculator.Here's a link to a financial calculator: http://www.fncalculator.com/financialcalculator?type=tvmCalculator Use this financial calculator to determine which loanrepayment option is better.COMPARISON #1Monthly payments for 5 years after you graduate, annualinterest rate of 6% compounded monthly.Monthly payments for 10 years after you graduate,annual interest rate of 6% compounded monthly.Fill in the tables with the values you put in the calculator.Select the better option (the least amount of total interestpaid)5 years10 yearsWhy might someone choose the other option in thiscase?Submit35 YEARSPresent ValuePayment AmountFuture ValueAnnual Interest ratePeriods (number ofpayments)CompoundingCalculate Total Interestpaid:10 YEARSPresent ValuePayment AmountFuture ValueAnnual Interest RatePeriods (number ofpayments)CompoundingCalculate Total Interestpaid:32,0000Monthly32,0000Monthly

Annuity: It is a series of equal disbursements over a period of time occurring at regular…

5 YEARS Present Value Payment Amount Future Value Annual Interest rate Periods (number of payments) Compounding Calculate Total Interest paid: 10 YEARS Present Value Payment Amount Future Value Annual Interest Rate Periods (number of payments) Compounding Calculate Total Interest paid: 32,000 0 Monthly 32,000 0 Monthly

5 YEARS Present Value Payment Amount Future Value Annual Interest rate Periods (number of payments) Compounding Calculate Total Interest paid: 10 YEARS Present Value Payment Amount Future Value Annual Interest Rate Periods (number of payments) Compounding Calculate Total Interest paid: 32,000 0 Monthly 32,000 0 Monthly

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter4: Managing Your Cash And Savings

Section: Chapter Questions

Problem 7FPE: Calculating interest earned and future value of savings account. If you put 6,000 in a savings...

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
Use Excel to answer this question: You want to borrow money from your bank to purchase a car. The maximum amount you are willing to pay is $450 per month. How much can you borrow if the loan lasts for 7 years, your first payment starts today, and the interest rate is 4.5% APR under monthly compounding? $32,495.13 O$29,489.45 O $31,576.98 O $27,456.87
Use the present value and future value tables to answer the following questions. A. If you would like to accumulate $2,600 over the next 5 years when the interest rate is 15%, how much do you need to deposit in the account? $fill in the blank 1 B. If you place $6,300 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? $fill in the blank 2 C. You invest $7,000 per year for 11 years at 12% interest, how much will you have at the end of 11 years? $fill in the blank 3 D. You win the lottery and can either receive $740,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why? Take the lump sum $740,000 because it is more money.
2. If you receive $99 each quarter for 17 years and the discount rate is 0.05, what is the future value? (show the process and can use financial calculator)
4. If you receive $116 each month for 28 years and the discount rate is 0.08, what is the present value? (show the process and can use financial calculator)
1. If you receive $29 each quarter for 19 years and the discount rate is 0.05, what is the present value? (show the process and can use financial calculator)
Review the compound interest formulas for n compoundings per year and for continuous compounding we learned this week. Do a quick check of the various interest offering from your favorite bank and then design a saving plan that would give you the most satisfactory savings in at the end of 2030 if you have only 5 extra dollars to be put away every day? interest rate =0.5%
Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $ Maximum mortgage at 3%: $
Suppose you have a student loan of $25,000 with an APR of 12% for 20 years. Complete parts (a) through (c) below. a. What are your required monthly payments? The required monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) b. Suppose you would like to pay the loan off in 10 years instead of 20. What monthly payments will you need to make? The monthly payment required to pay off the loan in 10 years instead of 20 is $ (Do round until the final answer. Then round to the nearest cent as needed.) c. Compare the total amount you'll pay over the loan term if you pay the loan off in 10 years versus 20 years. Total payments for the 20-year loan = $ Total payments for the 10-year loan = $
Use the Excel NPV() function to calculate the maximum loan you would be willing to give today for a borrower to make 8 years of $18,000 payments at 10 percent interest.
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.