Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. richard borrowed 50,000 from a bank at 12% (apr) s

Richard borrowed 50,000 from a bank at 12% (APR) semiannually compounded interest to be repaid in...

90.2K

Verified Solution

Question

Finance

Richard borrowed 50,000 from a bank at 12% (APR) semiannuallycompounded interest to be repaid in 10 years (12 equalinstallments) . Calculate the interest and principal paid in thefourth year. USE EXCEL FORMULAS SO I CAN SEE THE INPUTS PLEASE ANDSHOW THE WORK I WANT TO LEARN IT!

Answer & Explanation Solved by verified expert
3.7 Ratings (381 Votes)
We are given the following informationLoan Period10Interest rate12PMT frequency2Loan amount50000We need to solve the following equation to arrive at therequired PMTSo the PMT is 435923 We can get the following scheduleYearOpening BalanceLoanPMTInterestPrincipal repaymentClosing    See Answer
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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Richard borrowed 50,000 from a bank at 12% (APR) semiannuallycompounded interest to be repaid in 10 years (12 equalinstallments) . Calculate the interest and principal paid in thefourth year. USE EXCEL FORMULAS SO I CAN SEE THE INPUTS PLEASE ANDSHOW THE WORK I WANT TO LEARN IT!

Other questions asked by students

Q

At the end of last month, Ajax Inc. had the following balancesin its accounts:Cash...At...

Accounting
Q

Polystyrene has been shown to be soluble in certain terpinene solvents. From the evidence below, determine...

Chemistry
Q

Identify several interventions used in the treatment of sex offenders from psychological, medical, and physical perspectives.

Psychology
Q

A spherical shell of radius a has a uniform surface charge density σ and rotates with a...

Physics
Q

As a body is projected to a high altitude above the earths surface, the variation of...

Mechanical Engineering
Q

Topic 1: Plato – the allegory of the cave Plato is inspired by his teacher Socrates, but...

Psychology
Q

10-35: A helical coil compression spring is needed for food service machinery. The load varies from...

Mechanical Engineering
Q

urrent comes out from positive terminal of battery energy is supplied by the battery to...

Physics
Q

Why did you measure 10 periods of the pendulum instead of just 1 Would your...

Physics
Q

4 Express the problem below as a system of linear equations and find the solution...

Algebra
Q

Bank Reconciliation The cash account of Abstract, Inc., disclosed a balance of $16,348.82 on October...

Accounting
Q

a) Explain the differences between yield to maturity (YTM) and coupon rate of a bond....

Finance