I need help with these questions. Can anyone help me? Thank you
a)
i) The present value of option 1 = $ 24,000
ii) The present value of option 2 is calculated as follows
Present value of option 2 = $ 32,164.91
iii) The present value of option 3 is calculated as follows
Present value option 3 = $34,899.92
-----------------------------------------------------------------------------------------------------
b)
Option 1 does not have interest cost.
Interest cost of option 2 = $ 32,164.91 - $ 24,000
Interest cost of option 2 = $ 8,164.91
Interest cost of option 3 = $34,899.92 - $ 24,000
Interest cost of option 3 = $10,899.92
--------------------------------------------------------------------------------------------------
c)
Interest cost percentage option 2 = 34.02%
Interest cost percentage option 3 = 45.42%
-----------------------------------------------------------------------------------------
d)
Car dealership want to finance the vehicle even if someone can fully afford the price because they earn commission for arranging the finance between the customers and the bank.
I need help with these questions. Can anyone help me? Thank you 2. You are planning...
2. You are planning to buy a 2020 Camry XE. Your local dealership has the following offers: i. Option 1: $24,000 cash ii. Option 2: $5,000 down and the balance financed with 72 monthly payments of $425 each at 4% annual interest. (8 points) I. Option 3: Zero down and the balance financed with 72 monthly payments of $550 each at 4.25% annual interest. a) Calculate the present value of each option b) Calculate the interest cost of each option...
F G 1 Problem 1 2 You are planning to puchase a new Volkswagen Jetta that on average sells for $20,000. 3 You can secure 4% annual interest rate if you decide to finance the purchase. You're 4 planning to borrow money for 48 months, repaying in equal monthly payments 5 at the beginning of each month 7. (a) List inputs and calculate your monthly payment? (3 pts) (b) what is the formula 9 enter inputs in cell B13? (7...
Please, be neat and detailed. Explanations would be great. I need to understand it. Thank you. 1. [5 points total] Drs. Bhattacharya and Malinowski are expecting their third child and therefore are in the market for a new, larger, home. They are looking at a traditional colonial style home with a swimming pool on Nottingham Terrace that will cost $999,000 to purchase. They are now comparing lending options and have identified two potential options. They have asked for your expert...
An auto dealership is advertising that a new car with a sticker price of $35,208 is on sale for $25,995 if payment is made in full, or it can be financed at 0% interest for 72 months with a monthly payment of $489. Note that 72 payments × $489 per payment = $35,208, which is the sticker price of the car. By allowing you to pay for the car in a series of payments (starting one month from now) rather...
This was all the information given! An auto dealership is advertising that a new car with a sticker price of $34,848 is on sale for $25,995 if payment is made in full, or it can be financed at 0% interest for 72 months with a monthly payment of $484. Note that 72 payments x $484 per payment = $34,848, which is the sticker price of the car. By allowing you to pay for the car in a series of payments...
An auto dealership is advertising that a new car with a sticker price of $34,848 is on sale for $25,995 if payment is made in full, or it can be financed at 0% interest for 72 months with a monthly payment of $484. Note that 72 payments × $484 per payment = $34,848, which is the sticker price of the car. By allowing you to pay for the car in a series of payments (starting one month from now) rather...
How much will be your payment if you were planning to buy a house for $175,000 with 10% down if a bank was willing to give you a 30-year loan at 4.5% interest per year compounded monthly? Payments are to be made at the end of each month. $589 $645 $798 $867 16.67 points QUESTION 2 Say you bought a house for $195,000 with 10% down, and financed it from a bank for a 30-year term at 5.00% interest...
Assume that you are planning on purchasing a new car. You are considering financing the $40,000 purchase price using a car loan arranged through the car dealership. The terms of the loan are: 8 years of fixed monthly payments, and 2.4% quoted annual periodic rate of interest (this will need to be converted to a monthly rate by dividing the annual rate by 12). Assuming the loan will be completely paid off by the end of the 8 years, determine...
Can you please solve these on Excel and show me how you solved it. Thank you so much. 6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?...
5. Notes Payable. a. Below market rate interest notes. Falk Company purchased a new Machine with a list price of $50,000. Falk paid $5,000 down and financed the balance over 4 years with monthly payments of $956.77 each. The stated interest rate was 1% annual. The low interest deal was Option 1 for the purchase, Option 2 was a $4,000 rebate. Record the purchase of the machine. Prepare a two period amortization table for the stated / legal rate Calculate...