$(3)$ If you were to make annual deposits of $$100$ over the next $15$ years earning $10\%$ per year, what would your balance be immediately after making your final deposit? Enter the inputs into the appropriate cells in column B and set this up so that your answer is displayed as a positive value.

$2(4)$ If you wanted to make annual withdrawals of $$100$ over the next $15$ years, earning $10\%$ per year, what one$-$time deposit would you need to make today? Use the inputs from column B from question #$3$ and set this up so that your answer is displayed as a positive value.

TVM ANNUITY

PMT

YEARS

RATE

FVA

PVA

$3$

$(5)$ Assume a $30-$year mortgage loan for $$250,000$ for $30$ years at an annual rate of $6\%.$ What would be your fixed annual and monthly payments? Enter the inputs into the appropriate cells in column B and set this up so that your answers are displayed as positive values. Round all values to two places after the decimal point.

$(6)$ For the loan in #$5,$ prepare the first two monthly payment rows of the amortization table.

$7$

$8$ LOAN AMOUNT

$9$ TERM OF LOAN N YEARS

$10$ ANNUAL INTEREST RATE

$11$ TERM OF LOAN IN MONTHS

$12$ MONTHLY INTEREST RATE

$13$ FIXED LOAN PAYMENT $($ANNUAL$)$

$14$ FIXED LOAN PAYMENT $($MONTHLY$)$

$16$ AMORTIZATION TABLE

$17$ PAYMENT

$18$

$1$

BEGINNING BALANCE

FIXED PAYMENT

INTEREST

PRINCIPAL

ENDING BALANCE

$$

$(3)$ If you were to make annual deposits of $$100$ over the next $15$ years earning $10\%$ per year, what would your balance be immediately after

$21$

making your final deposit? Enter the inputs into the appropriate cells in column B and set this up so that your answer is displayed as a positive value.

$22$

$(4)$ If you wanted to make annual withdrawals of $$100$ over the next $15$ years, earning $10\%$ per year, what one$-$time deposit would you need to make

$23$

today? Use the inputs from column B from question #$3$ and set this up so that your answer is displayed as a positive value.

$24$ TVM ANNUITY

$26$

$27$ PMT

$28$ YEARS

$29$ RATE

$31$ FVA

$32$ PVA