Your client needs to borrow money in order to support the

firm's cash flow needs over the next few years.

The loans available are the following:

Loan #$1$: int rate loan balance

$3\%,10000$

Loan #$2$: int rate Ioan balance

$7$

$8$ Total amount needed to be borrowed.

Annual payment:

Note that the final payment will be less than this and will pay off

whatever is owed.

Your client should pay off the highest interest rate loan first, but note that

both loans will accumulate interest until paid in full.

The total payment can be divided between the two loans however your

$15$

client sees fit.

A

B

C

D

E

F

G

H

L

$1$ Your client needs to borrow money in order to support the

$2$ firm's cash flow needs over the next few years.

$3$ The loans available are the following:

$4$ Loan #$1$: int rate loan balance

$5$

$6$ Loan #$2$: int rate loan balance

$712\%$ no limit

$8$ Total amount needed to be borrowed.

$9$ Annual payment:

$3\%,10000$

$10$ Note that the final payment will be less than this and will pay off

$11$ whatever is owed.

$12$

$13$ Your client should pay off the highest interest rate loan first, but note that

$14$ both loans will accumulate interest until paid in full.

The total payment can be divided between the two loans however your

$15$

client sees fit.

Need help with finance

How to input the answer into excel once complete