India Calculate cash budget

[d.harish008]

Hi
I am an MBA student and I am doing analysis of a fititious company. I need to create cash budget. but the opening balance from previous month has not been given. But instead i have balance sheet. Now how do I calculate the opening balance previous year balance sheet. Below is my balance sheet. Now please guide me how to get the closing balance from this. Is it retained earnings or the cash and cash equivalent.

Particulars	2023​
Assets
Current Assets
Cash and cash equivalents	80.11​
Marketable securities	237.33​
Accounts Receivable	250.75​
Prepaid assets	5.27​
Total Current Assets	573.46​
Non-current Assets
Property and equipment	32.25​
Accumulated depreciation	-15.00​
Long term investments	6.25​
Intangible assets	84.95​
Total Non-Current Assets	108.45​
Total Assets	681.91​
Liabiliities
Current liabiliites
Short-term debt	2.72​
Accounts Payable	13.53​
Policy Holder Liabilities	311.20​
Deferred liabilities	0.82​
Total Current Liabilities	328.27​
Non-current liabilities
Long-term debt	5.97​
Deferred liabilities	1.34​
Employee benefits	9.53​
Total Non-Current Liabilities	16.84​
Total Liabilities	345.11​
Shareholders' Equity
Common stock	305.86​
Retained earnings	30.94​
Total equity	336.80​

 

[kirby]

No way. You would need a proforma income statement in order to forecast future cash. And you don't have that. You also don't have, as you pointed out, the previous cash balance. Not enough info here to do anything with it.