India Calculate cash budget

Joined
Nov 9, 2023
Messages
3
Reaction score
0
Country
India
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

VIP Member
Joined
May 12, 2011
Messages
2,451
Reaction score
334
Country
United States
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
11,646
Messages
27,602
Members
21,421
Latest member
termux

Latest Threads

Top