Cash flow formula for staggered payment

A

anirbangoa

New Member
Joined
Jun 16, 2020
Messages
3
Office Version
  1. 2007
Platform
  1. Windows
I am trying to make a cash flow statement for a real estate project where the payments are staggered and are paid based on % completion of the project.
I have attached an example sheet for reference.
Is it possible to do the calculation without using any other cell for storing shortfall amounts?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Capture.JPG
 
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Question
Credit payments table month over month Excel
Replies
0
Views
268
yanm11
Y
I
  • Question
Construction Budget distribution using GAMMADIST Function
Replies
4
Views
317
ibrahimdaas
I
J
  • Question
Simple Excel Formulas Not Showing Correct Answer (shows Dash or 0 depending on formatting) NOT a "Numbers Stored As Text" issue!
Replies
6
Views
712
Alex Blakenburg
A
C
  • Question
Use Row Data to Create New Sheet from Template and Reference Data
Replies
0
Views
428
ChrisMas92
C
W
  • Locked
  • Question
additional pop up msgbox dependent on specific text entered into userform combobox, and other questions
Replies
2
Views
316
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,216,083
Messages
6,128,718
Members
449,465
Latest member
TAKLAM

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top