I need help with excel ppmt and ipmt

[idonovan]

Hi all, I need help again with excel homework.

this is what it is asking me:

d. Using your knowledge of Financial functions; determine the monthly mortgage payment and the amount of principle and interest allotted in the 6th monthly payment. Refer to the values in cells B25 and B26 in these functions, using absolute referencing when required. Note the results should display as negative values.

Attached is a screen shot of what im doing the numbers im getting seem odd or wrong to me. I included the box where you type the values for the ppmt one to see if that is the issue.

e. In cell G4, you are asked to calculate the total amount of money that has been spent to purchase the property. Note: this is a formula, not a function, and must include absolute cell references and must take into consideration any money spent on the acquisition of the property.

I dont know how to get this

please help thank you

[idonovan]

bump