Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are starting a F & B business and needing to borror $200.000 from The bank offers you two options: 1) a 3% annual interest
You are starting a F & B business and needing to borror $200.000 from The bank offers you two options: 1) a 3% annual interest rate for a 2 year loan, or 2) a 4% annual interests rate for a 4 year loan Please use the PHT excel function to 1) calculate monthly payment, interest, principle and balance 2) calculate total interests paid for both options and decide which one ends up paying more interests 24 months loan Paymen Interest Principle Balance 200,000 48 months loan Paymen Interest Principl Balance Total Interests Paid
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