+ Reply to Thread
Results 1 to 2 of 2

Formula to apply excess cash to outgoing payment

  1. #1
    Registered User
    Join Date
    12-06-2021
    Location
    Canada
    MS-Off Ver
    Excel for 365
    Posts
    1

    Formula to apply excess cash to outgoing payment

    Hello,

    I am working with a large runoff model that accounts for all incoming cash from business activities and all outgoing cash for the same for a period of 84 months, which end result is to calculated the NPV of the net cash.

    I am trying to incorporate a formula that would allocate any excess net cash towards the prom note so this debt is paid down faster. However this is obviously resulting in a circulur reference error.

    Does anyone have an idea on a formula to get this to work? I can't hard code the net cash number because the model is always changing and the hard coded number may change and not be relevant anymore. I have attached a sample with a few rows, let me know if any other details are needed.

    Thanks for the help!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,744

    Re: Formula to apply excess cash to outgoing payment

    Hello and Welcome to Excel Forum.
    Would it be correct to assume that the desired value for cell C9 is 608333.33?
    I would think about restructuring the spreadsheet to resemble how you might keep the records if you were using pencil and paper.
    I assume that you would not set it up such that you would have to continually erase and rewrite the values in C9 and C12.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Excel data shotout cash span bank payment total
    By tariqjahangir in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2021, 04:16 AM
  2. Cash flow formula for staggered payment
    By anirbantemp in forum Excel General
    Replies: 2
    Last Post: 10-19-2020, 03:40 AM
  3. Deducting Payment in Cash Flow Analysis
    By MonkeyNuts80 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2020, 09:15 AM
  4. Interest payment formula for uneven cash flows
    By Jairam Jana in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-24-2019, 11:06 AM
  5. Deferred Payment Cash Flows with Dates
    By primeranetworks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2018, 03:59 PM
  6. Help with my cash flow forecast - changing when a payment kicks in
    By mattyh1986 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-12-2012, 08:32 AM
  7. How to do a macro for Payment Voucher, Cash Book, and Bank Checks/Cheques?
    By Susan Soo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2005, 10:11 PM

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