AutoSave OFF BESUDE X 10.0 - A Financial Function Excel file Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LO Arial 10 . Ai v = = ab Wrap Text {"480 Custom V DA TIX s v Paste B IU A % Insert .00 00 0 Merge & Center Delete Format V Conditional Format Formatting as Table Cell Styles Sort & Filter Ideas v Find & Select E7 4 x fx A B D E F F G H 1 J L M N 0 P Q R s y w Y Z Payment 5 pts 1 Loan Analysis Worksheet 2 3 Purchase Price $ 350,000 4 Payments per Year 12 5 Down Interest Duration Loan 6 Option# Payment Ratelyr lyrs) Value 7 1 0% 2.75% 15 8 2 20% 2.25% 15 9 3 0% 3.75% % 20 10 4 20% 3.25% 20 11 5 0% 5.50% 30 12 6 10% 5.00% 30 13 7 7 20% 4.50% 30 14 If Suzy wants to keep her payments below $1,500 per month which option should she choose? 15 1pt If she wants to pay off her loan quickly with the lowest monthly payment - which option should she choose? 16 1pt 1pt If she doesn't have much money for a down payment which option(s) should she choose? 17 18 Since Suzy selected Option 6, the Amortization Table shows the pertinent information about her decision 19 and resulting Principal and Interest Payments. How much in Principal Payments will Suzy pay during the 30 year mortgage? 20 1pt 1pt 1pt 3 pt How much in Interest Payments will Suzy pay during the 30 year mortgage? 21 At which period number (or payment) of the Mortgage will Suzy pay about the same in both Principal and 22 Interest Payment? 23 If she takes Option 2, but makes a $2,000 payment per month, how many years will it take her to repay the 24 loan? (Show as positive number. Don't forget to convert to years). If she decides to take option 3, but keep her payments at $2,000, what will her balance be at the end of the 25 loan? If she decides to take Option 1, but wants to keep her payments at $2,000, what interest rate does she need to get in order to do that? (Don't forget to convert to annual percentage rate.Show answer with 2 decimal 26 places. 27 28 29 30 31 3 pt 3 pt 19 Loan Analysis Amortization Table + Ready 1 0 + 100% AutoSave OFF BESUDE X 10.0 - A Financial Function Excel file Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X LO Arial 10 . Ai v = = ab Wrap Text {"480 Custom V DA TIX s v Paste B IU A % Insert .00 00 0 Merge & Center Delete Format V Conditional Format Formatting as Table Cell Styles Sort & Filter Ideas v Find & Select E7 4 x fx A B D E F F G H 1 J L M N 0 P Q R s y w Y Z Payment 5 pts 1 Loan Analysis Worksheet 2 3 Purchase Price $ 350,000 4 Payments per Year 12 5 Down Interest Duration Loan 6 Option# Payment Ratelyr lyrs) Value 7 1 0% 2.75% 15 8 2 20% 2.25% 15 9 3 0% 3.75% % 20 10 4 20% 3.25% 20 11 5 0% 5.50% 30 12 6 10% 5.00% 30 13 7 7 20% 4.50% 30 14 If Suzy wants to keep her payments below $1,500 per month which option should she choose? 15 1pt If she wants to pay off her loan quickly with the lowest monthly payment - which option should she choose? 16 1pt 1pt If she doesn't have much money for a down payment which option(s) should she choose? 17 18 Since Suzy selected Option 6, the Amortization Table shows the pertinent information about her decision 19 and resulting Principal and Interest Payments. How much in Principal Payments will Suzy pay during the 30 year mortgage? 20 1pt 1pt 1pt 3 pt How much in Interest Payments will Suzy pay during the 30 year mortgage? 21 At which period number (or payment) of the Mortgage will Suzy pay about the same in both Principal and 22 Interest Payment? 23 If she takes Option 2, but makes a $2,000 payment per month, how many years will it take her to repay the 24 loan? (Show as positive number. Don't forget to convert to years). If she decides to take option 3, but keep her payments at $2,000, what will her balance be at the end of the 25 loan? If she decides to take Option 1, but wants to keep her payments at $2,000, what interest rate does she need to get in order to do that? (Don't forget to convert to annual percentage rate.Show answer with 2 decimal 26 places. 27 28 29 30 31 3 pt 3 pt 19 Loan Analysis Amortization Table + Ready 1 0 + 100%