Hello

Pls find problems and solutions, II need solutions in Excel file with formulas.

Problem 3:

What interest rates are implied by the following lending arrangements?

a. You borrow $500 and repay $555 in one year.

b. You lend $1,850 and are repaid $2,078.66 in two years.

c. You lend $750 and are repaid $1,114.46 in five years with quarterly compounding.

d. You borrow $12,500 and repay $21,364.24 in three years under monthly

compounding.

(Note: In c and d, be sure to give your answer as the annual nominal rate.)

Solution:

FV = PV [FVF_k,n]

a. $555 = $500 [FVF_k,1]

FVF_k,1 = 1.1100

k = 11%

b. $2,078.66 = $1,850.00 [FVF_k,2]

FVF_k,2 = 1.1236

k = 6%

c. $1,114.46 = $750.00 [FVF_k,20]

FVF_k,20 = 1.4859

k = 2%

k_nom = 8%

d. $21,364.24 = $12,500.00 [FVF_k,36]

FVF_k,36 = 1.7091

k = 1.5%

k_nom = 18%

Problem 4:

How long does it take for the following to happen?

a. $856 grows into $1,122 at 7%.

b. $450 grows into $725.50 at 12% compounded monthly.

c. $5,000 grows into $6724.44 at 10% compounded quarterly.

Solution:

PV = FV [PVF_k,n]

a. $856 = $1,122 [PVF_7,n]

PVF_7,n = .7629

n = 4 years

b. $450.00 = $725.50 [PVF_1,n]

PVF_1,n = .6203

n = 48 months = 4 years

c. $5,000 = $6,724.44 [PVF_2.5,n]

PVF_2.5,n = 0.7436

n = 12 quarters = 3 years

Problem 6:

Branson Inc. has sold product to the Brandywine Company, a major customer, for $20,000. As a courtesy to Brandywine, Branson has agreed to take a note due in two years for half of the amount due, and half in cash.

a. What is the effective price of the transaction to Branson if the interest rate is:

(1) 6% (2) 8% (3) 10% (4) 12%?

b. Under what conditions might the effective price be even less as viewed by Brandywine?

Solution:

a. 1) PV = FV [PVF_6,2] = $10,000 (.8900) = $8,900

$8,900 + $10,000 = $18,900

Effective Discount = 5.5%

2) PV = FV [PVF_8,2] = $10,000 (.8573) = $8,573

$8,573 + $10,000 = $18,573

Effective Discount = 7.1%

3) PV = FV [PVF_10,2] = $10,000 (.8264) = $8,264

$8,264 + $10,000 = $18,264

Effective Discount = 8.7%

4) PV = FV [PVF_12,2] = $10,000 (.7972) = $7,972

$7,972 + $10,000 = $17,972

Effective Discount = 10.1%

b. The discount from Brandywine's viewpoint is calculated as in part a) however, using the interest rate at which that firm borrows. If Brandywine's rate is higher than Branson's, it will observe a greater discount.

Problem 10:

How much will $650 per year be worth in eight years at interest rates of

a. 12%

b. 8%

c. 6%

Solution:

FVA = PMT [FVFA_k,n]

a. FVA = $650 [FVFA_12,8] = $650 (12.2997) = $7,994.81

b. FVA = $650 [FVFA_8,8] = $650 (10.6366) = $6,913.79

c. FVA = $650 [FVFA_6,8] = $650 (9.8975) = $6,433.38

Problem 18:

Sam Rothstein wants borrow $15,500 to be repaid in quarterly installments over five years at 16% compounded quarterly. How much will his payment be?

Solution:

For quarterly compounding we have

k = k_nom/12 = 16%/4 = 4%

n = 5 years x 12 months/year = 60 months.

Write equation of 6.19 and substitute.

PVA = PMT[PVFA_k,n]

$15,500 = PMT[PVFA_4,60]

Using Appendix A-4

$15,500 = PMT[22.6235]

PMT = $685

Problem 21:

Construct an amortization schedule for a 4 year, $10,000 loan at 6% interest compounded annually.

Solution:

PVA = PMT [PVFA_k,n]

$10,000 = PMT [PVFA_6,4]

PMT = $2,885.92

Year	Beg Bal ($)	PMT ($)	Int ($)	Prin Recd ($)	End Bal ($)
1	10,000.00	2,885.92	600.00	2,285.92	7,714.08
2	7,714.08	2,885.92	462.84	2,423.08	5,291.00
3	5,291.00	2,885.92	317.46	2,568.46	2,722.54
4	2,722.54	2,885.92	163.35	2,722.54	0.00