Financial Numbers In Red Must Be NegativeFunctions

FV Interest Per Period0.0100

PV Interest Per Period0.0100

PMT Interest Per Period0.0100

IRR -203.53.53.53.53.53.53.53.53.53.5

NPER Interest Per Period0.0100

NPV Payments Per Period ($M)-203.53.53.53.53.53.53.53.53.53.5

RATE # Of Periods360

Nominal Effective0.1268

Effective Nominal0.1200

Loan Amount: $200,000Interest Rate / year: 5.00%

Term (yrs): 30

Year # Cumulative Interest In Year #1 -$9,9332 -$9,9333 -$9,9334 -$9,9335 -$9,9336 -$9,9337 -$9,9338 -$9,9339 -$9,933

10 -$9,933. .. .. .. .. .

# Of Periods Payments Per Period360.00 -$300.00

# Of Periods Payment Per Period360 -$300.00

# Of Periods Present Value (Lump Sum)360 -$10,000.00

IRR0.11725

Payments Per Period Present Value (Lump Sum)-$300.00 -$10,000.00

Interest Per Period0.11725

Payment Per Period Present Value-$300.00 -$10,000.00

# Of Periods Per Year Nominal12 0.1200

# Of Periods Per Year Effective12 0.1268

Cumulative Principal In Year # Total Annual Payments-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884-$2,951 -$12,884

.

.

.

.

.

Present Value (Lump Sum) Future Value-$10,000.00 $1,407,985.65

Future Value PV-$50,000.00 $30,556.33

Future Value Payment Per Period$5,000,000.00 -$1,327.77

Future Value (Lump Sum) # Periods Required$5,000,000.00 485.8427

NPV$0.0004

Future Value # Periods Per Year Rate$1,048,489.24 12 0.1076