I need to find a Private loan (2) duration and see if a CD Value enough for down payment Attached is my excel sheet and I will post the exact questions. Also if you feel like checking my entire sheet I would not mind as i think i did it right but am not sure

here are the questions:

1. Diana is negotiating with the seller and is willing to pay $10,000 per quarter at 6.5% interest per year compounded quarterly. She will borrow everything but a 10% down payment. Determine how many years it will take to pay off the loan (cell E18).

2. Ten years ago, Diana invested $75,000 in a bank CD. The CD has earned 3.25% annual interest compunded yearly. Determine (TRUE/FALSE) if diana has sufficient funds from this CD for the Downpayment for Option #1 ( cell E19).

3. Diana has decided that she prefers a bank loan and, given cash flow issues, wants the loan with the smallest payment. Highlight in blue the cell in Column H containing the payment of the loan Diana should select. Now using conditional formatting, highlight the cell containing the minimum payment value, so that if any of the values on any other bank loans are later modified, the correct value will be automatically highlighted.

Insert Draw Page Layout Formulas Data Review View Tell me what you want to do Share Wrap Text Conditional Format as Cell Insert Delete Format Clear Sort & Find & Filter Select 000 Formatting Table Styles. Clipboard E18 fr -NPER(6.5%/4,-10000,E3-(E3*10%),0,0) Loan Analysis Worksheet $500,000 3 4 5 Purchase Price Number of Compounding Periodslyear Optional Balloon Pa $ 20,000 Actual Nominal DownInterest Duration Loan Monthly Amount Payment 7 Option# Payment | 20%) 10% 5%, 0%) 20%, 10% Rate/yr | 4.90% 5.25% 5.75% 6.25% 5.50% 6.00% 6.50% (yrs) | Points Fees | Value | Payment Borrowed, APR with Balloon 30 30 30 30 30 15 3 375 400,000 ($6,380.11) 387,625 5.18% ($6,454.12 3, 375 450.000! ($7,468.13)| 436,125. 5.53%-($7,537.55) 3 375 475,000! ($8,330.79)| 0500,000 0400.000| ($9,252.07) ($6,825.69)| 460.375. 6.04% ($8,394.06) 485,000 6.54% ($9,309.65 396,000, 5.59%. ($6,891.98) 449,650 6.01% ($11,634.91) 12 1. 0 350 450.000|($11,427.04) 350 475,000|($12,452.81) 15 0 474,650 6.51% ($12,652.14) 16 17 Private loan (1) annual rate 18 Private loan (2) duration 19 CD value enough for down 20 21 5% 81.52 23 24 25 27 28 Sheetl + 100%|