+ Reply to Thread
Results 1 to 3 of 3

Present value of cash flows

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Chicago, Il
    MS-Off Ver
    MS 16
    Posts
    6

    Present value of cash flows

    Hoping someone can point me in the right direction. I need to build out a present value of cash flows for debt payments for the auditors in excel and cannot find a template in Microsoft 360. I have the calculations done on an online calculator but cannot transfer to excel. Does anyone know if there is a standard template in excel to use or is this something I will need to build manually.

    Dave

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,224

    Re: Present value of cash flows

    Are you using a financial model that fits in the PV() family of functions, so you can use the PV() function? https://support.microsoft.com/en-us/...1-da16e8168cbd

    Or something more like the NPV() family of functions so you can use the NPV() function? https://support.microsoft.com/en-us/...b-ac28acf2a568

    Or something more like the XNPV() family of function so you can use the XNPV() function? https://support.microsoft.com/en-us/...b-d67c16b664b7

    Or some other financial model?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-18-2020
    Location
    Chicago, Il
    MS-Off Ver
    MS 16
    Posts
    6

    Re: Present value of cash flows

    Mr. Shorty, thanks for the response. It appears what I need is this one
    the XNPV() family of function so you can use the XNPV() function

    We are replacing old debt with new debt and the auditors need to determine the present cash flows of each debt to determine the proper accounting treatment. We have quarterly interest and loan payments and they want us to determine the PV of those payouts through the balloon payment at the end of the loan. The financial calculators online are informative but I have to build out an excel model to be able to show the logic behind it. I will look into the link you attached.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IRR with Missing Cash Flows???
    By $J$L$G in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-05-2017, 03:12 AM
  2. [SOLVED] uncertain cash-flows timing. create monthly cash report
    By excobra in forum Excel General
    Replies: 3
    Last Post: 05-14-2014, 11:10 AM
  3. Waterfall Cash Model, dividing up cash flows based on IRR
    By tomservo2009 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-21-2008, 05:57 PM
  4. [SOLVED] IRR for 2 cash flows
    By Maxymus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2006, 08:45 PM
  5. IRR formula for monthly cash flows
    By MB Burgis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2006, 11:10 PM
  6. Present Value of Remaining Cash Flows
    By Stratuser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2005, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1