Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Interest Rate & Time Value of Money Develop a payment calculator using EXCEL. Assume that interest will be compounded daily. Your input should include: a
Interest Rate & Time Value of Money
(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 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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started