(USING EXCEL FUNCTION PLEASE) You wish to plan your Bahamas Islands vacation. You estimate that it will be two years from now, and that it will cost $15,000. The monthly payment you should save in order to finance your vacation is $637.66 assuming that you make 24 monthly payments, starting today and ending 23 months from now. what is the annual percentage rate?

(USING EXCEL FUNCTION PLEASE) You wish to plan your Bahamas Islands vacation. You estimate that it will be two years from now, and that it will cost $15,000. The monthly payment you should save in order to finance your vacation is $637.66 assuming that you make 24 monthly payments, starting today and ending 23 months from now. what is the annual percentage rate?

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

Chapter5: Making Automobile And Housing Decisions

Section: Chapter Questions

Problem 8FPE

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?
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that you have the following two loans with monthly payments in the table attached as Choice 1 and Choice 2. Assuming that there is no origination cost with the loans. If Robin pays off the loan in 15 years(180 months), what is the incremental cost of the $10,000 for loan 1 over loan 2?
you want to buy a car for $8300 with $360 monthly payments for 4 years, what is the annual interest rate? please answer as an excel spread sheet, thank you!
Suppose you are thinking of availing a loan of P100,000 at Pag-ibig Funds for house repairs after typhoon Jolina. Interest is pegged at 14% compounded quarterly, and you intend to make equal quarterly payments to pay-off this loan in three years. Set-up an amortization schedule (table) to serve as your guide in tracking the payments made, interest paid, principal repaid and outstanding principal for each period.
using excel do the following Create an amoritization schedule for a $1,000,000 loan that requires equal annual payments in each of the next 10 years. The annual rate is 6%. How much is the remaining loan balance after 5 years? Analyze the amount of each equal payment that goes towards interest and principal in each year. What do you notice?
You want to vacation in Paris for the summer months in 7 years. You determine your expenses to be approximately 15,000 in today’s dollar worth. If the rate of inflation is running 3% a year, what should your goal be for the trip?
You decide to buy a car for $15,000.00 and decide to make payments of $1,100 each month. If the loan is 3% compounded monthly, how many full months of payments will it take to pay off the $15,000.00? What is the amount of the smaller concluding payment one month later?It will take months of full payments.The smaller concluding payment is $ .(Round to 2 decimal places.) Submit QuestionQuestion 7
You want to borrow $94,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $1,900, but no more. Assuming monthly compounding, what is the highest rate you can afford on a 60-month APR loan?
You have decided to start saving for an extended overseas trip in five years’ time. If you put $800 per month into a savings account at ANZ earning 2.5% p.a. compounding monthly at the beginning of each month, how much will you have after five years? How much interest will you have earned over the period?
suppose you want to be able to withdraw $4,800 at the end of each month for the next 20 years. How much would you need to have in the account at the beginning if you can earn 7.5% annually?
You are considering two ways of financing a spring break vacation. You could put it on your credit card, at 14% APR, compounded monthly, or borrow the money from your parents, who want an interest payment of 10% every six months. Which is the lower rate? (Note: Be careful not to round any intermediate steps less than six decimal places.)