In the example, the first value for the Principal PMT was 199.10 in cell E18. Answers for
Question:
In the example, the first value for the Principal PMT was 199.10 in cell E18. Answers for the questions must follow the example answer.
(1-2 use first picture)
1. Calculate the Principal PMT and Balloon Payment using IF statements. with respect to cell C12
2. Calculate the Principal PMT and Balloon Payment using True/False Statements (Boolean Expressions (T/F))
(3-5 use second picture)
3. Calculate the Principal PMT and Balloon Payment using Vlookup Function with respect to cell C6
4. Calculate the Principal PMT and Balloon Payment using IndexMatch with respect to cell C6
5. Calculate the Principal PMT and Balloon Payment using OffsetMatch function with respect to cell C6
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen