subject
Business, 01.02.2021 22:20 ericahale3971

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 the monthly payment associated with loan, and then prepare an amortization table in a similar way as shown in the class Excel example. Include all of the months in your table, and make sure you show not only the beginning and ending balance for each month, but also the monthly payment and the breakdown between the part used to pay interest and the part used to pay down the principal. (Hint: use functions and formulas in the first row, and the beginning balance in the second row, in a way that will allow you to copy and paste to the remaining cells of your table)

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 20:30
Elizabeth believes her company has discriminated against her because her minority coworkers, who are less qualified, have been promoted ahead of her. which agency should elizabeth contact? - national alliance of business- affirmative action council- equal employment opportunity commission- federal trade commission- fair employment practices agency
Answers: 2
question
Business, 22.06.2019 01:50
Atlas manufacturing produces a unique valve, and has the capacity to produce 50,000 valves annually. currently atlas produces 40,000 valves and is thinking about increasing production to 45,000 valves next year. what is the most likely behavior of total manufacturing costs and unit manufacturing costs given this change? a. total manufacturing costs will increase and unit manufacturing costs will also increase. b. total manufacturing costs will stay the same and unit manufacturing costs will stay the same. c. total manufacturing costs will increase and unit manufacturing costs will decrease. d. total manufacturing costs will increase and unit manufacturing costs will stay the same.
Answers: 1
question
Business, 22.06.2019 08:40
During january 2018, the following transactions occur: january 1 purchase equipment for $20,600. the company estimates a residual value of $2,600 and a five-year service life. january 4 pay cash on accounts payable, $10,600. january 8 purchase additional inventory on account, $93,900. january 15 receive cash on accounts receivable, $23,100 january 19 pay cash for salaries, $30,900. january 28 pay cash for january utilities, $17,600. january 30 firework sales for january total $231,000. all of these sales are on account. the cost of the units sold is $120,500. the following information is available on january 31, 2018. depreciation on the equipment for the month of january is calculated using the straight-line method. the company estimates future uncollectible accounts. at the end of january, considering the total ending balance of the accounts receivable account as shown on the general ledger tab, $4,100 is now past due (older than 90 days), while the remainder of the balance is current (less than 90 days old). the company estimates that 50% of the past due balance will be uncollectible and only 3% of the current balance will become uncollectible. record the estimated bad debt expense. accrued interest revenue on notes receivable for january. unpaid salaries at the end of january are $33,700. accrued income taxes at the end of january are $10,100
Answers: 2
question
Business, 22.06.2019 15:30
Brenda wants a new car that will be dependable transportation and look good. she wants to satisfy both functional and psychological needs. true or false
Answers: 1
You know the right answer?
Assume that you are planning on purchasing a new car. You are considering financing the $40,000 purc...
Questions
question
Mathematics, 02.07.2021 19:30
question
Mathematics, 02.07.2021 19:30
question
Chemistry, 02.07.2021 19:30
question
English, 02.07.2021 19:30
question
Mathematics, 02.07.2021 19:40
Questions on the website: 13722367