subject
Business, 24.04.2021 02:00 885122bah

Mann Co. is preparing an Excel spreadsheet for its 5-year, 6%, $400,000 installment notes. The notes were issued on January 1 for $421,236. Installment payments are payable each December 31. A portion of the spreadsheet appears as follows: A B C D E 1 Effective rate: 0.06 2 Cash payments: 100,000 3 Term to maturity in years: 5 4 5 Period Cash Payment Interest Expense Change in Balance Outstanding Balance 6 0 7 1 8 2 What formula should Mann use in cell E8 to calculate the outstanding balance (book value) of the notes after the second interest

ansver
Answers: 3

Another question on Business

question
Business, 21.06.2019 13:30
Marine corps leaders use coaching to scrutinize their subordinates to identify proficiency and conduct marking ranges.
Answers: 1
question
Business, 21.06.2019 20:30
Afactory owner wants his workers to produce as many widgets as they can so he pays his workers based on how many widgets they produce. however, in order to make sure that the workers do not rush and produce a large number of poorly made widgets, he checks the widgets at random at various stages of their manufacture. if a defect is found in a widget, the pay of the entire section of the factory responsible for that defect is docked. how is this factory owner seeking to solve the agency conflict problem in this case?
Answers: 2
question
Business, 22.06.2019 03:40
Your parents have accumulated a $170,000 nest egg. they have been planning to use this money to pay college costs to be incurred by you and your sister, courtney. however, courtney has decided to forgo college and start a nail salon. your parents are giving courtney $20,000 to her get started, and they have decided to take year-end vacations costing $8,000 per year for the next four years. use 8 percent as the appropriate interest rate throughout this problem. use appendix a and appendix d for an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. how much money will your parents have at the end of four years to you with graduate school, which you will start then?
Answers: 1
question
Business, 22.06.2019 13:30
If the economy were in the contracting phase of the business cycle, how might that affect your ability to find work?
Answers: 2
You know the right answer?
Mann Co. is preparing an Excel spreadsheet for its 5-year, 6%, $400,000 installment notes. The notes...
Questions
question
Mathematics, 25.01.2020 17:31
question
Mathematics, 25.01.2020 17:31
question
Mathematics, 25.01.2020 17:31
Questions on the website: 13722367