I need help in working out the PROIV logic for the following Amortisation formular please:-

A = $100,000

n =

**360**(30 years times 12 monthly payments per year)

i = .

**005**(6% expressed as .06 divided by 12 payments per year)

D =

**166.7916**({[(1+.005)^360] - 1} / [.005(1+.005)^360])

P = A / D = 100,000 / 166.7916 =

**599.55**

Thanks in advance,

Matthews Estrice