LO O acom Cut 22. Wrap Text Paste 14 AA BIU2OA Format Painter Merge & Center $ % 9 8 -98 Conditional Format as c Formatting Table Style cpboard fi DIRECTIONS DIRECTIONS On the next slide you will find a loan for which you need to calculate a series of EQUAL TOTAL PAYMENTS - 3 fill it out with the formulas covered in class On the slide after you will find a loan for which you need to calculate a series of EQUAL PRINCIPAL PAYMENTS - fill it out with the formulas covered in class Finally, on the last slide, you will find a loan which you will amortize using a series of EQUAL TOTAL PAYMENTS with a balloon payment at the end of the tenth payment - fill it out with the formulas covered in 5 class D ARNA DIRECTIONS Equal Principal Payment Equal Total Payment Baloon Payment 11 3 Paste cut Copy Format Painter Clipboard Calibri BIU - AA A 2 3 Wapter Merge & Center $ % 899 Condition Format Font Alignment Number fx APR D G H 4.75% Machinery Shed 1 APR 2 Years 3 Payments per Year 4 Amount 57,899 6 Payment Number Debt Service Principal Interest Balance COM 19 TOTAL ENTAR Calibri = General Paste X Cut Copy Format Painter Clipboard - X -11AA O A 23 Wrap Text Merge & Center - BI E s $ - % * 8-98 Font Conditional Forma Formatting Table Styles Number V fx APR G H I 6.50% Tractor 1 APR 2 Years 3 Payments per Year 4 Amount 225,750 Payment Number Debt Service Principal interest Balance w No 13 TOTAL m0NOSENNEMSNIS Tanamant Balcon Paument ew View Help o Paste X Cut Copy - Calibri BIU - 11 - AA - - General Format Painter lili Wrap Text Merge & Center $ % 8-9 Conditional Format a Formatting Table Clpboard Font Number Styles for APR F 1 APRIL G H I 4.25% Car J K L 3 Payments per Year 38,000 nime 6 Payment Number Debt Service Principal interest Balance ORENANT DIRECTIONS Equal Principal Payment Equal Total Payment Baloon Payment