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.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

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 75th payment? Please show both regualr and formula format of the spreadsheet.
After starting your first full-time job out of college, you decide to buy a new car for $12,000. Using Excel, create a complete amortization table for this car-loan: You make 36 equal end- of-month payments. The discount rate is 7.25% compounded monthly. How much would you owe after the 15th payment is made? Use excel to solve
Diane is deciding between two personal loans. For each loan, the loan amount is $7500. Use the ALEKS loan calculator for the following. Also use the regular ALEKS calculator, as necessary. Write your answers to the nearest cent. ALEKS Loan Calculator Loan amount: $ Loan term: Interest rate: Calculate years % Monthly payment: (a) For Loan A, the interest rate is 6.15% per year and the loan term is 7 years. Find the total amount to repay Loan A. S (b) For Loan B, the interest rate is 6.15% per year and the loan term is 5 years. Find the total amount to repay Loan B. (c) For which loan would she pay less, and by how much? Loan A The total amount paid is $ less. Loan B The total amount paid is $less. X Ľ
Suppose you want to have $600,000 for retirement in 25 years. Your account earns 4% interest. How muc would you need to deposit in the account each month? Submit Question /course/showcalendar.php?cid=179278 Search
Hazel has taken out a 40,000 loan that requires quarterly payments of $2300 over over five years. What is the APR for this loan how do I answer this using the TVM function
You take out an $19,000.00 car loan that calls for 48 monthly payments at an APR of 6.7%. Complete an amortization table and answer the following questions. You must complete the amortization table to answer the questions (otherwise your answers could be off due to rounding error... all totals are based on intermediate numbers that have not been rounded). The answer you enter must be rounded (correctly) to two decimal places. You do not need to include commas or dollar signs in your answer. For example, the end balance after 41 months would be entered as 3096.82. What is the total interest paid on the loan?
You take out an $19,000.00 car loan that calls for 48 monthly payments at an APR of 6.7%. Complete an amortization table and answer the following questions. You must complete the amortization table to answer the questions (otherwise your answers could be off due to rounding error... all totals are based on intermediate numbers that have not been rounded). The answer you enter must be rounded (correctly) to two decimal places. You do not need to include commas or dollar signs in your answer. For example, the end balance after 41 months would be entered as 3096.82. What is the total amount you paid on the loan?
You need additional cash for the payment of your tuition fee and other expensesfor your studies. Because of your premium contributions to RV INVESTMENTS two yearsago, you are already eligible to apply for RV INVESTMENTS Student Multi-Purpose Loanworth Php 40,000 with 10% annual interest rate payable within 2 years. Computefor the Monthly Payment and Prepare Amortization Schedule (3 months paymentonly). TOPIC: Principle of Finance
Suppose that you decide to borrow $15,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 5.9% Installment Loan B: five-year loan at 4.8% P Use PMT = to complete parts (a) through (c) below. - nt 1- 1+ a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.)
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: Use this information for the questions below. Use the Buying a Car information above to answer this question. You want to make monthly payments of $449, but you don't want a car loan over your head for more than 48 months, so you decide to go with the down payment option. How much of a down payment do you need to make? $_____ . Round to the nearest dollar
Angela's bank gave her a 2-year add-on interest loan for $6,120 to pay for new equipment for her antiques restoration business. The annual interest rate is 8.28%. How much interest will she pay? What are her monthly payments? Question content area bottom Part 1 She will pay $enter your response here in interest on the loan. (Round to the nearest cent.) Part 2 Her monthly payments are $enter your response here. (Round to the nearest cent.)
You are to receive $ 400,000 exactly 5years from now. You do not want towait for the money and contact JTGoneworth so that they can "Show youthe money" today. JT Goneworthrequires 6 % interest (annual) on thistype of loan. How much with JTGoneworth pay you TODAY for thisclaim on the money to be received 5years from now? ______