trying to do pmt for both monthly payments and the financial summary? please help urgert!!

1 B D E 1 Financial Review for Company X Value Last Present Growth PV Percent 2. Investments Year Value Rate to Total 3 Risky A $575,000 $667,000 16.0% 4.45% 4 Risky B $750,000 $840,000 12.0% 5.61% 5 Moderate A $2,500,000 $2,650,000 6.0% 17.69% 6 Moderate B $1,850,000 $1,998,000 8.0% 13.34% 7 Conservative A $3,500,000 $3,622,500 3.5% 24.19% 8 Conservative B $5,000,000 $5,200,000 4.0% 34.72% 9 Total $14,175,000 $14,977,500 5.7% 10 Average $2,362,500 $2,496,250 5.7% 11 12 Mortgage Details for Headquarters Annual Interest Repayment Monthly 13 Rate Years Principal Payments 4.50% 30 $5,000,000 =PMT( 15 PMT (rate, nper, pv, [fv], [type]) 16 Lease Details for Vehicles Time of Present Future Annual Interest Lease in Value of Value of Monthly 17 Rate Years Vehicles Vehicles Payments 18 2.50% 4. $200,000 $80,000 19 20 Financial Summary 21 Future Value of Investments in Two Years 22 Two Year Change in Investments 23 Two Years of Mortgage Payments 24 Two Years of Lease Payments 25 Investment Gains Less Mortgage and Lease Payments 26 14 Sheet1 1 B D E 1 Financial Review for Company X Value Last Present Growth PV Percent 2. Investments Year Value Rate to Total 3 Risky A $575,000 $667,000 16.0% 4.45% 4 Risky B $750,000 $840,000 12.0% 5.61% 5 Moderate A $2,500,000 $2,650,000 6.0% 17.69% 6 Moderate B $1,850,000 $1,998,000 8.0% 13.34% 7 Conservative A $3,500,000 $3,622,500 3.5% 24.19% 8 Conservative B $5,000,000 $5,200,000 4.0% 34.72% 9 Total $14,175,000 $14,977,500 5.7% 10 Average $2,362,500 $2,496,250 5.7% 11 12 Mortgage Details for Headquarters Annual Interest Repayment Monthly 13 Rate Years Principal Payments 4.50% 30 $5,000,000 =PMT( 15 PMT (rate, nper, pv, [fv], [type]) 16 Lease Details for Vehicles Time of Present Future Annual Interest Lease in Value of Value of Monthly 17 Rate Years Vehicles Vehicles Payments 18 2.50% 4. $200,000 $80,000 19 20 Financial Summary 21 Future Value of Investments in Two Years 22 Two Year Change in Investments 23 Two Years of Mortgage Payments 24 Two Years of Lease Payments 25 Investment Gains Less Mortgage and Lease Payments 26 14 Sheet1