Business, 08.10.2020 08:01 ljdavies51

Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Complete an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 $ $ $ $ $ 3 $ $ $ $ $ b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places. % Interest % Principal Year 1: % % Year 2: % % Year 3: % %

Answers: 1

Show answers

Other questions on the subject: Business

Business, 22.06.2019 10:30, khenalilovespandas

Marketing1. suppose the average price for a new disposable cell phone is $20, and the total market potential for that product is $4 million. topco, inc. has a planned market share of 10 percent. how many phones does topco have the potential to sell in this market? 20,0002. use the data from question 3 to calculate topco, inc.'s planned market share in dollars. $400,0003. atlantic car rental charges $29.95 per day to rent a mid-size automobile. pacific car rental, atlantic's main competitor, just reduced prices on all its car rentals. in response, atlantic reduced its prices by 5 percent. now how much does it cost to rent a mid-size automobile from atlantic? $28.45

Answers: 1

continue

Business, 22.06.2019 15:00, Jocelynrichards

Why entrepreneurs start businesses. a) monopolistic competition b) perfect competition c) sole proprietorship d) profit motive

Answers: 1

continue

Business, 22.06.2019 18:30, fggfg33

Jason started last week with $900 in his checking account. during the week, he wrote the checks below. at the end of the week, jason received a paycheck for $534.59. he recorded all of these transactions in his check register. trans typ./ check no. date description of transaction payment/ debit deposit/ credit (+) balance 900 00 241 12/4 miller's food market 53.21 53 21 groceries 846 79 242 12/7 frank's auto parts 24.05 24 05 oil and filter 822 74 243 12/8 mike's barber shop 15.00 15 00 haircut 807 74 deposit 12/9 paycheck 534.59 534 59 1,342 33 evaluate jason's check register. a. jason did a good job; everything is correct. b. the final balance is wrong; jason did not add everything correctly. c. jason should have written debit instead of deposit for the transaction type. d. jason entered the amount for his paycheck in the wrong column.

Answers: 3

continue

Business, 22.06.2019 19:30, buggamarshall85

The owner of firewood to go is considering buying a hydraulic wood splitter which sells for $50,000. he figures it will cost an additional $100 per cord to purchase and split wood with this machine, while he can sell each cord of split wood for $125. if, for this machine, design capacity is 50 cords per day, effective capacity is 40 cords per day, and actual output is expected to be 32 cords per day, what would be its efficiency?

Answers: 1

continue

You know the right answer?

Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the...