Budget calculator for Excel?

[Outdoorsman80]

Hi,

I'm trying to get my head around building this into our finances sheet and not sure where to start.
What I want to do is have something like this https://www.calculators.org/budget/ - I want to specify a accounts with percentages and want to specify say a surplus of cash, and then divide it up.

Surplus Cash: $100.00

[TABLE="width: 500"]
<tbody>[TR]
[TD]Mortgage Principal Payment - 50%[/TD]
[TD]Calculated amount[/TD]
[/TR]
[TR]
[TD]Car Down-payment - 25%[/TD]
[TD]Calculated amount[/TD]
[/TR]
[TR]
[TD]Savings - 25%[/TD]
[TD]Calculated amount[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Outdoorsman80]

I figured it out... it's been a long day, I had to look at it differently... It's a simple formula.

 

[smozgur]

It's a simple formula.

Please mark a post as a solution only if that post contains a solution. Marking a post that mentions it is a simple formula doesn't make the marked post a solution. If you could post the solution for this old thread, then it is perfectly fine to mark your post as the solution. Otherwise, please leave it as is.