Suppose you take out a $$106,000,20-$year mortgage loan to buy a condo. The interest rate on the loan is $6\%.$ To keep things simple, Complete this question by entering your answers in the tabs below.

Req A

Req B

Req $C$ and $D$

Req $H$

Req I$1$

Req I$2$ and J

Recompute the amortization table.

Note: Do not round intermediate calculations. Round your answers to $2$ decimal places. Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Enter all values as positive value.

$\backslash$table$[[\backslash$table$[[$Year$]],\backslash$table$[[\backslash$table$[[$Beginning$-$of$-],[$Year$],[$Balance$]]]],\backslash$table$[[$Year$-$End$],[$Interest Due$],[$on Balance$]],\backslash$table$[[$Year$-$End$],[$Payment$]],\backslash$table$[[$Amortization$],[$of Loan$]],\backslash$table$[[$End$-$of$-$Year$],[$Balance$]]],[1,,,,,],[2,,,,,],[3,,,,,],[4,,,,,],[5,,,,,],[6,,,,,],[7,,,,,],[8,,,,,],[9,,,,,],[10,,,,,],[11,,,,,],[12,,,,,],[13,,,,,],[14,,,,,],[15,,,,,],[16,,,,,],[17,,,,,],[18,,,,,],[19,,,,,],[20,,,,,]]$ Suppose you take out a $$106,000,20-$year mortgage loan to buy a condo. The interest rate on the loan is $6\%.$ To keep things simple

we will assume you make payments on the loan annually at the end of each year.

a$.$ What is your annual payment on the loan?

b$.$ Construct a mortgage amortization.

c$.$ What fraction of your initial loan payment is interest?

d$.$ What fraction of your initial loan payment is amortization?

e$.$ What is the total of the loan amount paid off after $10$ years $($halfway through the life of the loan$)?$

f$.$ If the inflation rate is $2\%,$ what is the real value of the first $($year$-$end$)$ payment?

g$.$ If the inflation rate is $2\%,$ what is the real value of the last $($year$-$end$)$ payment?

h$.$ Now assume the inflation rate is $8\%$ and the real interest rate on the loan is unchanged. What must be the new nominal interest

rate?

i$-1.$ Recompute the amortization table.

i$-2.$ What is the real value of the first $($year$-$end$)$ payment in this high$-$inflation scenario?

j$.$ What is the real value of the last payment in this high$-$inflation scenario?

Complete this question by entering your answers in the tabs below.

Req $B$

Req $C$ and $D$

Req $E$ to $G$

Req I$1$

Req I$2$ and J

$i-2.$ What is the real value of the first $($year$-$end$)$ payment in this high$-$inflation scenario?

j$.$ What is the real value of the last payment in this high$-$inflation scenario?

Note: Do not round intermediate calculations. Round your answers to $2$ decimal places.

we will assume you make payments on the loan annually at the end of each year.

a$.$ What is your annual payment on the loan?

b$.$ Construct a mortgage amortization.

c$.$ What fraction of your initial loan payment is interest?

d$.$ What fraction of your initial loan payment is amortization?

e$.$ What is the total of the loan amount paid off after $10$ years $($halfway through the life of the loan$)?$

f$.$ If the inflation rate is $2\%,$ what is the real value of the first $($year$-$end$)$ payment?

g$.$ If the inflation rate is $2\%,$ what is the real value of the last $($year$-$end$)$ payment?

h$.$ Now assume the inflation rate is $8\%$ and the real interest rate on the loan is unchanged. What must be the new nominal interest

rate?

i$-1.$ Recompute the amortization table.

i$-2.$ What is the real value of the first $($year$-$end$)$ payment in this high$-$inflation scenario?

j$.$ What is the real value of the last payment in this high$-$inflation scenario?

Complete this question by entering your answers in the tabs below.

e$.$ What is the total of the loan amount paid off after $10$ years $($halfway through the life of the loan$)?$

f$.$ If the inflation rate is $2\%,$ what is the real value of the first $($year$-$end$)$ payment?

g$.$ If the inflation rate is $2\%,$ what is the real value of the last $($year$-$end$)$ payment?

Note: Do not round intermediate calculations. Round your answers to $2$ decimal places.