Use Excel Be organized. Use Excel formulas/functions. SHOW 4 DECIMALS. A firm will be requesting...
70.2K
Verified Solution
Link Copied!
Question
Finance
Use Excel Be organized. Use Excel formulas/functions. SHOW 4 DECIMALS. A firm will be requesting a loan of \\( \\$ 150 \\mathrm{~K} \\) from a bank. o The Closing fees for the loan amount to \\( \\$ 3,500 \\) and they cannot be financed. o The bank is willing to give the loan to be repaid over 3 years, at an APR of 2.0\\%. o the loan must be paid back in monthly payments, starting at the end of the 1 st month. a) what is the effective interest rate? b) what is the monthly payment? c) what are the details of each monthly payment ? DEVELOP A PAYMENT TABLE showing the details of each payment, FOR THE DURATION OF THE LOAN d) if the company decides to make an additional payment of \\( \\$ 500 \\) every month, how long (in months) will it take to repay the debt
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Use Excel Be organized. Use Excel formulas/functions. SHOW 4 DECIMALS. A firm will be requesting a loan of \\( \\$ 150 \\mathrm{~K} \\) from a bank. o The Closing fees for the loan amount to \\( \\$ 3,500 \\) and they cannot be financed. o The bank is willing to give the loan to be repaid over 3 years, at an APR of 2.0\\%. o the loan must be paid back in monthly payments, starting at the end of the 1 st month. a) what is the effective interest rate? b) what is the monthly payment? c) what are the details of each monthly payment ? DEVELOP A PAYMENT TABLE showing the details of each payment, FOR THE DURATION OF THE LOAN d) if the company decides to make an additional payment of \\( \\$ 500 \\) every month, how long (in months) will it take to repay the debt 