Calculate your monthly payment using excel pmt function

Assignment Help Financial Management

Reference no: EM131959031

You decide to take advantage of the dealers 0.9% financing to purchase your next car. You negotiate a price of $32,000 for the car of your dreams and put $8,000 down., borrowing the rest on a 36-month loan. Calculate your monthly payment using excel PMT function, then create an ammortization table for your loan showing the payoff of your loan over time. How much interest do you pay in month 5? How much interest do you pay in month 35? Why the difference? (I will need to verify the formulas using formulatext)

Reference no: EM131959031

Questions Cloud

Consistent with the firm primary goal : Which of the following is consistent with the firm's primary goal?

Compare and explain types of e-business technologies : Compare and explain various types of e-business infrastructure technologies, business models, and payment and security systems in a corporate setting

Value of operations-value of equity and stock price : Calculate Reston's value of operations, value of equity and the stock price.

Select and circle the proper choice : In the following sentences, select and circle the proper choice, inside of each set o parentheses, so that the sentences will be accurate and logical:

Calculate your monthly payment using excel pmt function : Calculate your monthly payment using excel PMT function, then create an ammortization table for your loan showing the payoff of your loan over time.

Calculate the molar solubility of silver thiocyanate : Calculate the molar solubility of silver thiocyanate, AgSCN, in pure water and in water containing 0.010 M NaSCN. Solve problem without ignoring x.

Supply target capital structure consists : Harvey's Industrial Plumbing Supply's target capital structure consists of 40% debt and 60% equity.

Explain the possible consequences in crop yields : As global food demand rises, climate change is hitting our staple crops. Explain the possible consequences in crop yields and subsequent price changes.

Compensation models for traders play into rogue trading : How much do compensation models for traders play into Rogue Trading?

User Account

All Pages