Task $7$: When btnCalculate is clicked:

a$)$ Compute the loan amount, which equals the current total car prices minus the down

payment or full payment as selected.

b$)$ Compute the monthly repayment using the VBA function PMT$.\{$Note: VBA function PMT

returns a negative value as payments are considered outgoing cash flows.$\}$

c$)$ Compute the total payment on the loan, which equals monthly repayment times the

number of repayment months.

d$)$ Display the above$-$computed values in a message dialog box like the one below. All money

values must have a $\text{'}$ $ $\text{'}$ symbol at the front and include a comma to separate thousands and

in $2$ decimal places:

Payment Information

Total car price: $$1,311,108\mathrm{.}00$

Loan amount: $$1,179,997\mathrm{.}00$

Monthly payment: $$39,192\mathrm{.}79$

Total loan payment: $$1,410,940\mathrm{.}29$

The above are the results of the following settings:

Car Loan Repayment Calculation

Car model and price in HK$:

Method of Payment

Down Payment

C Full Pay

$10\%$

$$131,111$

Number of repayment months: $36$

Monthly interest rate: Could you help me with this excel vba question. Commnets. are required. Your detailed explanations will be highly appreciated!