Log in

View Full Version : Bidgeted Income statement


crazy4tobe
Apr 16, 2009, 01:30 PM
How Do I do a budgeted balance sheet? I already have a budgeted statement of cash receipts and dsiburssements for 3 months ending March 31 and the budgeted income statement for the 3 months ending March 31. I have all of the necessary information to do it. I just am having trouble on how to do the calculations to do a budgeted blance sheet.
(schedule a,b, c, & d... Sales budget, cash collections, purchase budget, disbursements for purchases) I have all of the information. Again just need to know the caluclations for a busgted balance sheet.:o

morgaine300
Apr 16, 2009, 02:04 PM
Depends on what information you have available and a problem like this could consist of a lot of different stuff.

In all cases, you'll have to take the beginning balances of the accounts and start adjusting what whatever info you have, all of which may be on the other work you did, or given somewhere else in the problem.

For instance, you can get the cash right off the cash budget. Something like receivables, you'll have to take beginning balance, and then figure ending balance based on the cash budget. You have to pull off what was credit sales and add it, and then what was collected on credit and subtract it.

The purchases budget would give you numbers for inventory. (Add whatever is to be purchased and subtract whatever is to be used. If there was a "desired ending inventory" given, then that's your ending balance right there.)

Use that income statement to update the balance in capital or retained earnings. (remember that net income adds to equity)

Etc.

But I don't know what all you have available and how many things you may have to figure out. With homework, there's not necessarily some specific way to get it done because who knows what information may be available.

But maybe that'll get you started.