Log In
Register
Home
New Member
December 22, 2020
Offline
Hi
I looked through a number of other posts but couldn't find an answer. I'm trying to get a 10 year calculated cashflow forecast of a superannuation/pension account. It is self managed and has real property, listed equities and cash components as the asset base (with different rates of capital and income return). This is all the easy bit. I use this to calculate the total value of the fund, then split the pension and accumulation balances from that.
I get to a loop situation where the amount of pension to be drawn down is based on the pension balance at the start of the period.
Can someone assist with the formula to get the pension drawdown amount per period, then subtract it from the end of period balance?
Cheers and thanks in advance, Al.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Alastair,
Please provide the math behind the required calculation, and an example with a manual calculation, including what cells are used in the example.
Finances is not my area of expertise, you have to provide the calculation chain and we'll help you with an excel formula.
New Member
December 22, 2020
Offline
Hey Catalin and crew,
I made a mistake in the order of my calculation. I should have been taking the % from the balance at the START of period, not END of period, which is where the error stemmed from.
Cheers, Al.
1 Guest(s)
