After starting your full-time job out of college, you decide to buy a new car for $85,000. Create a complete amortization table in excel for this car loan: You make 84 equal end-of-month payments. The discount rate is 6.5 percent compounded quarterly. How much would you owe after the 75 th payment? Please show both regualr and formula format of the spreadsheet.

After starting your full-time job out of college, you decide to buy a new car for $85,000. Create a complete amortization table in excel for this car loan: You make 84 equal end-of-month payments. The discount rate is 6.5 percent compounded quarterly. How much would you owe after the 75 th payment? Please show both regualr and formula format of the spreadsheet.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You attend college and have 2 loans: A SUBSIDIZED loan for $40,000 with 3.88% APR, and anUNSUBSIDIZED loan for $28,000 with 4.06% APR. You plan to elect standard repayment. Calculate yourtotal monthly payment for both loans.
A friend of yours bought a new sports car with a $4,500 down payment plus a $27,000 car loan that is financed at an interest rate of 0.75% per month for 60 months. a. Calculate the required monthly loan payment on the car. b. How much does your friend still owe on the car loan immediately after she makes the 24th monthly payment? c. If, after the 24th payment, she decides to pay $100 more each month, how many months will it take her to payoff the remaining loan she owes? a. The required monthly payment is (Round to the nearest cent.) b. Your friend still owes $on the car loan. (Round to the nearest dollar.) c. It will take her months (Round-up to the nearest month)
Use an online loan calculator to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $148,000. The bank requires a 20% down payment and three points at the time of closing The cost of the home is financed with a 30-year fixed rate mortgage at 85% Complete parts (a) through (e) below -CHEDD a. Find the required down payment $0 b. Find the amount of the mortgage How much must be paid for the three points at closing? (Round to the nearest dolar as needed) d. Find the monthly payment (excluding escrowed taxes and insurance) (Round to the nearest dollar as needed) e. Find the total cost of interest over 30 years (Round to the nearest dolar as needed)
In order to start a small business, a student takes out a simple interest loan for $3000 for 9 months at a rate of 11.25%. a. How much interest must the student pay? b. Find the future value of the loan.
After deciding to buy a new car, you can either lease the car or purchase it on a three- year loan. The car you wish to buy costs $35,000. The dealer has a special leasing arrangement where you pay $99 today and $499 per month for the next three years. If you purchase the car, you will pay it off in monthly payments over the next three years at a 6 percent APR. You believe you will be able to sell the car for $23,000 in three years. What break-even resale price in three years would make you indifferent between buying and leasing? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Break-even sale price What is the present value of purchasing the car? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) $ Present value
Need help with this question please. Thank you!
You take out an installment loan to purchase a sailplane costing $34,200. You make a down payment of $8,600 and finance the balance by making monthly payments of $1,156.72 for 24 months. Use the APR formula to find the APR.
Create an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will pay on this loan. Copy the table from Step 1, make an extra principal payment of $2,000 on the first day of year two. How does this change the total interest you will pay on this loan? Create an amortization table in Excel for a new car loan for 30,000 for three years at 5%. Determine the total amount of interest you will pay on this loan. Copy the table from Step 3, change the interest rate to 2%. How does this change the total interest that you will pay on the loan? What is the total amount you will pay for the car (principal and interest) in each of the steps 1, 2, 3 and 4.
You decide to create a savings account for your children's college education, putting $140 permonth into an account paying 6.1% compounded monthly. What will be the value of theaccount in eighteen years? (Please help by using calculator)
You open a new business and need a new laptop computer. You decide on a Knox Computer Solutions for $1499 due to the business software that is included. If the sales tax is 4.25% of the purchase price and you finance the total cost, including sales tax, for 3 years at the annual interest rate of 8.4%, find the monthly payment amount.
You are purchasing a new car for $27,600. The dealership offers you three options: 0% financing: 0 down and 0% financing for 48 months. Rebate: 0 down. If you choose the rebate, you will need to secure a loan for the balance at your local bank. Down payment: Make a down payment of 5% or more and get financing at 1.5% compounded monthly for 48 months. The rebate offer is $1900, and you can obtain a car loan at your local bank for the balance at 2.03% compounded monthly for 48 months. If you choose the rebate, what is your monthly payment? $ _______ . Round to the nearest dollar.
You are purchasing a new car for $27,600. The dealership offers you three options: • 0% financing: 0 down and 0% financing for 48 months. • Rebate: 0 down. If you choose the rebate, you will need to secure a loan for the balance at your local bank. • Down payment: Make a down payment of 5% or more and get financing at 1.5% compounded monthly for 48 months:

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS