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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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
255
yanm11
Y
I
  • Question
Construction Budget distribution using GAMMADIST Function
Replies
4
Views
262
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
668
Alex Blakenburg
A
C
  • Question
Use Row Data to Create New Sheet from Template and Reference Data
Replies
0
Views
393
ChrisMas92
C
W
  • Locked
  • Question
additional pop up msgbox dependent on specific text entered into userform combobox, and other questions
Replies
2
Views
287
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,547
Messages
6,125,461
Members
449,228
Latest member
moaz_cma

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