Interest Rate & Time Value of Money

Develop a payment calculator using EXCEL. Assume that interest will be compounded daily. Your input should include: a # of payment periods (months); b Loan amount; c Interest rate expressed as an APR. Develop a loan amortization table similar to the one shown below. In this question, Please use theses data: Loan Amount: $36,000; Interest(APR%): 6%; payment time: 36months (Your real payment time might be shorter than this).

(Insert Data Here) Inputs(Variables) Loan Amount(P) Payment Time(Months) Interest(APR)(%) M (Compound Frequency) k (# of payments/yr.) Requirement You input the given data in the orange cell. Then relavent values will be shown in green cells as well as blank cells in the following table automatically. If I use other data, say $40,000, then values would change as well. Formulas TER periodical Rate (1+pr/M)^M-1 (1) (1/k)-1 Payments Monthly payment Total Principal Paid Total Interest Paid Total Payment End of Period Monthly Payment Interest Payment Extra Payment Balance 0 1 2 3 4 5 6 (Insert Data Here) Inputs[Variables) Loan Amount(P) Payment Time Months) Interest(APR)(%) M (Compound Frequency) k (# of payments/yr.) Requirement. You input the given data in the orange cell. Then relavent values will be shown in green cells as well as blank cells in the following table automatically. If I use other data, say $40,000, then values would change as well Formulas Rate (1+pr/M) M-1 (1+1)^(1/k)-1 periodical Payments Monthly payment Total Principal Paid Total Interest Paid Total Payment End of Period Monthly Payment Interest Payment Extra Payment Balance 0 1 2 3 4 5 6 7