Ask Experts Questions for FREE Help !
Ask
    ChristyWendell's Avatar
    ChristyWendell Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 16, 2008, 07:44 PM
    calculating NPV
    How do I calculate the net present value.

    Problem:
    Lump Sum Payment of $500,000
    Needs to be grossed up 35% for taxes
    Paid out over 5 years @ annual interest rate of 4%

    What would the monthly payout amount be over 60 months?
    stevetcg's Avatar
    stevetcg Posts: 3,693, Reputation: 353
    Ultra Member
    		  
    #2

    Dec 17, 2008, 06:36 AM

    Check with the homework help section.
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #3

    Dec 19, 2008, 10:36 AM

    If you have Excel, search for "amortization schedule" in Microsoft Office online help - you will find a handy spreadsheet that you can download and figure this out.
    Alternatively, if you want to build your own spreadsheet - the monthly payment can be calculated from:
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Calculating depreciation [ 1 Answers ]

What will be the depreciation amount if a company commenced in jan 2000 and it is having an asset of 100000 and the rate of depreciations is 10 percent and the company is winded up in June 2001 ,so what will be the depreciation amount

Calculating NPV [ 1 Answers ]

Hi I am new to this site and hope that there is someone out there who can help me. I have to calcualte NPV for a project that has no specific inflows and I don't know where to start, any help will be appreciated. Regards Sian:

View more questions Search