Learning Objectives

Prepare a fully referenced worksheet using absolute and relative references where appropriate.

Demonstrate an understanding of how the budget flows and consolidates.

Prepare financial statements from a budget.

Prepare a summary cash budget.

Project

Universal Electronics is a small, rapidly growing wholesaler of consumer electronic products. The firm's main product lines are small kitchen appliances and power tools. The general manager of marketing has completed the sales forecast. She believes the sales during the first quarter of $203$ will increase by $10\%$ each month over the previous month's sales. Then she expects sales to remain constant over the next several months. The company's projected balance sheet as of December $31,20$x$2$ is as follows:

$\backslash$table$[[$Cash$,$$$28,000$Learning Objectives

Prepare a fully referenced worksheet using absolute and relative references where appropriate.

Demonstrate an understanding of how the budget flows and consolidates.

Prepare financial statements from a budget.

Prepare a summary cash budget.

Project

Universal Electronics is a small, rapidly growing wholesaler of consumer electronic products. The firm's main product lines are small kitchen appliances and power tools. The general manager of marketing has completed the sales forecast. She believes the sales during the first quarter of $203$ will increase by $10\%$ each month over the previous month's sales. Then she expects sales to remain constant over the next several months. The company's projected balance sheet as of December $31,20$x$2$ is as follows:

$\backslash$table$[[$Cash$,$$$28,000$