subject
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: % %

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 00:50
Hanna intends to give her granddaughter, melodee, her antique hat pin. this heirloom has been kept under lock and key in the wall vault in the library of hanna's house in virginia. the hat pin is currently the only item in the vault. when hanna is visiting melodee in connecticut, hanna gives melodee the only key to the vault. melodee is grateful for the present and excitedly accepts. in this situation has there been a completed gift?
Answers: 3
question
Business, 22.06.2019 14:00
Why is efficiency an important economic goal?
Answers: 2
question
Business, 22.06.2019 18:50
Retirement investment advisors, inc., has just offered you an annual interest rate of 4.4 percent until you retire in 40 years. you believe that interest rates will increase over the next year and you would be offered 5 percent per year one year from today. if you plan to deposit $13,000 into the account either this year or next year, how much more will you have when you retire if you wait one year to make your deposit?
Answers: 3
question
Business, 22.06.2019 19:20
1. revising for conciseness - eliminating flabby expressions,limiting long lead-ins, and dropping unnecessary fillerstime is money in any business environment. people want information communicated quickly and clearly. to make your writing more concise and understandable, avoid flabby expressions, long lead-ins, and unnecessary fillers. your audience will appreciate your brevity.1. if your writing contains a flabby expression like in view of the fact that, replace it with the word because / although / probably .for each of the following two sentences, choose the best revision.2. i am sending you this letter to inform you that we have experienced an unexpected surprise within our expense sheet, but we are positively certain we will solve it.1) we need to inform you that we have experienced an unexpected surprise with our expense sheet, but we are midway to an end result.2) we have identified a problem with our expense sheet, but we will solve it.3) i am sending you this letter to inform you that we have a problem with our expense sheet, but we are positively certain we have a solution.3. it is the user who should contact the center.1) everyone knows that it is the user who should contact the center.2) the user should contact the center.3) if there is a problem, the user should contact the center.read the following passage, and then answer the question.[1] you scheduled seven conference calls for this morning between 10 and 11 a.m. [2] generally, the company limits the number of conference calls to three per hour. [3] i’m letting you know that in the future, we should be more careful about scheduling.4. which revision limits the long lead-in in sentence 3? 1) in the future, we should be more careful about scheduling.2) i’m letting you know so that in the future we are more careful about scheduling calls.3) so that you know in the future, we should be more careful about scheduling.
Answers: 3
You know the right answer?
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the...
Questions
question
Advanced Placement (AP), 11.01.2021 19:10
question
Mathematics, 11.01.2021 19:10
question
History, 11.01.2021 19:10
Questions on the website: 13722367