Complete Mae's pro forma balance sheet and the cash budget for the months of January, February,...

 

Transcribed Image Text:

Complete Mae's pro forma balance sheet and the cash budget for the months of January, February, and March only. Identify how much additional funds Mae requires (if any). When entering dollar values, omit the dollar sign. Please save your work for partial credit. The following information is in the Excel sheet, but included below for reference: Mae is considering keeping her flower business open on Sundays next year. If she does so, she hopes for an additional 10% increase in sales but will have to pay an additional $2500 in SGA (wages). Mae would like a minimum cash balance of at least $2000. She has already completed a pro forma income statement. Complete her pro forma balance sheet. Will any additional funds be needed next year and if so, how much? Additionally, prepare a month cash budget for January, February, and March. Monthly sales and materials orders are shown. Mae would like to keep at least $2000 cash on hand at all times. Additionally, she is expecting a $200 tax payment in January and a $800 interest payment also in January. Her SGA expenses are paid at $1200 every month. She is starting January with cash of $2300 and existing financing of $1250. Complete Mae's pro forma balance sheet and the cash budget for the months of January, February, and March only. Identify how much additional funds Mae requires (if any). When entering dollar values, omit the dollar sign. Please save your work for partial credit. The following information is in the Excel sheet, but included below for reference: Mae is considering keeping her flower business open on Sundays next year. If she does so, she hopes for an additional 10% increase in sales but will have to pay an additional $2500 in SGA (wages). Mae would like a minimum cash balance of at least $2000. She has already completed a pro forma income statement. Complete her pro forma balance sheet. Will any additional funds be needed next year and if so, how much? Additionally, prepare a month cash budget for January, February, and March. Monthly sales and materials orders are shown. Mae would like to keep at least $2000 cash on hand at all times. Additionally, she is expecting a $200 tax payment in January and a $800 interest payment also in January. Her SGA expenses are paid at $1200 every month. She is starting January with cash of $2300 and existing financing of $1250.