Question

Show calculation of how to solve the problems (hand calculation instead of excel) 1a) Bubba bought...

Show calculation of how to solve the problems (hand calculation instead of excel)

1a) Bubba bought a car for $60,000, putting down $20,000 cash and financing the remainder. How much are his monthly car payments if he financed the car for 6 years and paid a nominal annual interest rate of 6 percent?

1b) How much will his payments be if he makes the payments at the beginning of each month?

Homework Answers

Answer #1

Since the payments are monthly, first let's get the monthly effective rate.

Monthly effective rate = ( 1 + 0.06)^ (1 month / 12 months) - 1

Monthly effective rate = (1.06)^(1/12) - 1

Monthly effective rate = 1.0048675506 - 1

Monthly effective rate = 0.0048675506 = 0.48675506%

a) Loan amount = Car price - down payment = 60,000 - 20,000 = 40,000. This is the PV.

n = 6 years * 12 payments = 72 payments

PMT = $659.9186

b) If the payments are made at the beginning of each month, then the new payments will be

PMT (beg) = PMT(end) / (1 + r)

PMT (beg) = 659.9186 / (1 + 0.0048675506)

PMT (beg) = $656.7219

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
a) Bubba bought a car for $60,000, putting down $20,000 cash and financing the remainder. How...
a) Bubba bought a car for $60,000, putting down $20,000 cash and financing the remainder. How much are his monthly car payments if he financed the car for 6 years and paid a nominal annual interest rate of 6 percent? b) How much will his payments be if he makes the payments at the beginning of each month?
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems (provided...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems (provided on page 5) on the applications of the time value of money. You are required to show the following four steps for each problem (sample problems and solutions are provided for guidance): (i) Develop a timeline (linear representation of the timing of cash flows). (ii) Identify the time value of money variable (PV, FV, PMT, N, or I/YR) that needs to be solved/calculated in...
Skeeter bought a new bass boat for $22,000. He made a $4,000 down payment and financed...
Skeeter bought a new bass boat for $22,000. He made a $4,000 down payment and financed the remainder at 14.5% for two years with monthly payments. Required: a. Prepare a loan amortization schedule for the first three payment periods. b. How much interest will Skeeter pay, assuming he pays the loan off according to schedule? c. How much will he owe immediately after making the thirteenth (13th) payment Daniel is considering an investment that will pay $25,000 per year for...
Time Value of Money I - Worksheet Identify the table that should be used for each...
Time Value of Money I - Worksheet Identify the table that should be used for each of the following situations in the space provided, then show the calculations to solve the problem below. FV – Future Value of 1 PV – Present Value of 1 FVA – Future Value of an Annuity PVA – Present Value of an Annuity _________ 1. Tom bought a zero-coupon bond with an 8% yield. (A zero-coupon bond does not pay interest, but the value...
Solve the following: 1. You want to be a millionaire in 25 years. If you can...
Solve the following: 1. You want to be a millionaire in 25 years. If you can earn 10% on your investments, how much do you have to save each year to hit that $1,000,000 mark? Table______________________ 2. Amy is 65 and has $350,000 in her retirement account. An actuary has determined that if her investments earn 7%, she can withdraw $32,300 annually. How many more years does the actuary expect Amy to live? Table______________________ 3. Karla sued her landlord 5...
*PLEASE ANSWER ALL QUESTIONS Problem 1: A credit car company wants your business. If you use...
*PLEASE ANSWER ALL QUESTIONS Problem 1: A credit car company wants your business. If you use their card, they deposit 1% of all your monetary transactions into a savings account that earns 5% per year. If you spend on average $20,000 dollars a year, how much money will you have in the savings account after 15 years? Problem 2: Sam wants 2 million dollars in net worth when he retires. In order to achieve this, he plans to invest $10,000...
Chapters 6, 7, and 10: Application of Interest Concepts to Notes, Bonds, and Leases The problems...
Chapters 6, 7, and 10: Application of Interest Concepts to Notes, Bonds, and Leases The problems below involve application of interest concepts to various liability-related scenarios. Required—Provide the information requested in each problem along with supporting calculations. 1. Corp1 issued $250,000 of 3-year bonds with 5% interest payable semiannually at a time when the market rate of interest was 6%. How much did the company receive in issuance proceeds? 2. Corp2 issued $500,000 of 4-year bonds with 6% interest payable...
Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $40,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $510 per year, payable at the start of each year Based on mileage estimates, petrol will cost $220...
Read the case study. Identify three (3) problems and recommendations to solve the problems. Each problem...
Read the case study. Identify three (3) problems and recommendations to solve the problems. Each problem will require a justified recommended solution at least a page each. Zappos CEO Asks Employees to Commit to Teal, or Leave Zappos had modest beginnings. In 1999, shoesite.com was started by Nick Swinmurn to capture online shoe sales. Swinmurn reached out to Tony Hsieh (pronounced “shay”) and Alfred Lin, who were running Venture Frogs, a kind of venture capital group, for advice and funding....
Read this case study and then answer the questions that follow. (The paragraphs are number 1...
Read this case study and then answer the questions that follow. (The paragraphs are number 1 to 13 for your convenience). 1. Mr Michael Maguire lives in Wombat, in the central west of New South Wales. Michael owns a 3000 acre farm in Young, and the main crop he grows is cherries. He has decided he needs to acquire a better and more efficient spraying machine. 2. Some specialist spraying machines are available in Toronto, Canada at the firm Maple...