Hello, I'm taking a selftest on line and I can't solve the following:
Evaluate the formula for the remaining principal amount of the sixth month.
If someone knows how to solve this and needs the Excel real file letme know so that I can send it.
Thank You
had to scroll down than select cell F16 click on Formula ribbon -> Formula Auditng Group -> Evaluate Formula and executed everything that had to be executed.
Last edited by Jack_Chiga; 12-04-2009 at 11:00 AM. Reason: solve
Isn't it just =F15-E16
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Did You look at the file attached?Originally Posted by NBVC
Jack
It's a .jpg so I only see what I see... the last column is the Remaining Principal Amount
You want to know what that should be at month 6... well it's the previous Remaining Amount minus the current Principal Paid.
Edit: There are also many function in Excel for calculating Amorization and Loan Payments. Look at the Financial group of Functions.
Last edited by NBVC; 12-03-2009 at 04:53 PM.
Re: Evaluate Formula for remaining principal amount
OK! then how would you answer the question:
Evaluate the formula for the remaining principal amount of the sixth month!
Jack
If for whatever reason, the self-test wants you to evaluate it without the table, try =FV(D4/12,6,F4,-D3). You'll get the same response with either formula, though.
Given what you gave here (just a picture).. I answered the way I would answer... maybe darkyam can help you more... I am out!
Jack, you are going to have to be both more polite and clearer in your requests if you want our continued assistance. I'd have answered exactly how NBVC did if I'd have seen this first. If you don't mean, "What formula gives me the remaining principal at the end of six months?" then what do you mean by "evaluate"?
letme uploads 4 more screenshots for the testing page to see if you can help me a little more. If not it was worth anyway.
Those are only two screenshots and you still haven't explained what you mean by "evaluate". In words, not images, what is it that you are asking us for?
sorry got a phone call in the middle!
he ya go
Sorry, but none of those help me understand what you mean by "evaluate". Does it mean it wants a verbal description (seems unlikely since you got an error message that appears to have been sent automatically)? Does it want simply the answer? Does it want either my or NBVC's formulas? Something else?
If anyone else reading this understands what I'm missing, feel free to chime in.
Evaluate the formula for the remaining principal amount of the sixth month.
I'm only trying to answer the question.
regards
Jack
Sorry, Jack, but without an explanation of what the test is looking for, there's no way I can help you and I rather doubt anyone else will be able to, either. Best of luck finding the answer. If you can come back with a more detailed explanation, please post it and we'll try to answer your question.
I'm sending an email to the developer of the website where I'm setf testing myself.
Thanks anyway
Jack Chiga.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks