Question: Answer this question using Excel. You buy a car for $29,500. The dealer offers financing at 8.5% APR, with $2,500 cash down, and monhtly payments

Answer this question using Excel. You buy a car for $29,500. The dealer offers financing at 8.5% APR, with $2,500 cash down, and monhtly payments for three years. In cell B2 compute the size of the payments. Starting in row 15, construct a full amoritzation schedule for your loan. Columns should include:

A: Payment B: Loan Balance at Start of Month C: Monthly Payment D: Interest Paid this Month E: Principal Repaid this month F: Loan Balance at the End of Month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Answer this question using Excel. You buy a car for $29,500. The dealer offers financing at 8.5% APR, with $2,500 cash down, and monthly payments for three years. In cell B2 compute the size of the...

Answer this question using Excel. You buy a car for $28,500. The dealer offers financing at 9.5% APR, with $2,500 cash down, and monthly payments for three years. In cell B2 compute the size of the...

There are 10 potential entrants into the market for tomatoes. All tomato growers are identical. They face a fixed cost of 500 if they choose to enter the market and then have a marginal cost of 10...

hh explain111 2. Use the geometric series formula to express the present value of payments through p, T and rm, where I'm is the monthly interest rate. Plug in the numeric value for p, 7 and put this...

I need help doing Present Value. Must use all 3 files to answer the questions. Direction: The first 5 pages will teach you about the basics of the present value calculation. Following are three...

Answer the question in excel format. Excel formulas are below. 1. Solve for the unknown variables (identified with a ?) based on the information provided. Maturity / Future Value Interest Amount ? ?...

Hello. I'm looking for some help completing my finance project. (10% total course grade) There are quite a few questions. (40 total) I can check the answers one time before submitting. Hoping for...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

PLEASE HELP ME URGENT !!! write one by one please solve; Head of Evtel Kitchen Appliances Milos wants to work with a start-up specializing in smart home technologies to expand EvTel's business. He...

2. Given the following currency exchange rates: Time period 1: AUD $1.25/ Time period 2: AUD $1.50/ a. The % change of the value of from time period 1 to time period 2 is: A) -20% B) +20% C) -16.25%...

Suppose you are very rich and very fat. Your doctor has advised you to limit your food intake to 2000 calories per day. What is your consumer equilibrium for food consumption?

Please help me complete the form 8 9 9 5 . 1 7 6 5 0 , 1 7 0 5 0 , and 3 3 8 0 0 has all been wrong for QBI. I need help figuring out what her true QBI is . Thank you!!! Show all images Show all...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

If the employment application you submit does not have all the blanks filled in, has smudges on it, and has words crossed out, what impression might the prospective employer have about you?...

You are considering creating an online rsum for your job search. Research publishing to the Web and answer the following questions. (Objective 4) a. Where will you publish (or post) your rsum? b. Is...

Technology. Convert the rsum you developed in Application Exercise 13 to a scannable rsum using keywords throughout. E-mail a copy to your instructor. (Objective 4)