Isabella has become the new Controller of Budget Inc., a revolutionary manufacturing business in BC.
Despite not having a solid accounting background, Isabella is looking to lead the way in making some
long-overdue organizational changes. She has been with Budget Inc. for almost three years, so she has
some ideas for improving processes.

Isabella's direct supervisor, Sophia, does not have an accounting background. When the previous CFO
retired suddenly last month, Emily was immediately promoted to the Chief Financial Officer role. She, in
turn, promoted Isabella, who had been in the finance department and had helped her with a few
projects, to Controller. The Controller role was a new one created by Emily to help deal with the
company's growing accounting demands.

Since Emily had worked as an administrative assistant to the previous CFO for five years, Isabella had
assumed she was fit to take over. Still, she wondered if perhaps the company lacks accounting
expertise/leadership. Seeing how the only other accounting employee in Budget Inc. is Susan, an
Accounting Assistant working under her, Isabella wonders if an external candidate would be better
suited for her Controller role.
The first thing for Isabella is to complete the budget for the year 2022. Because of the sudden leave of
the CFO, the budget for 2022 is not finished.
Budget Inc. has completed all operating budgets except the income statement for 2022. Selected data
from these budgets follow.
 Sales: $300,000
 Purchases of raw materials: $80,000
 Ending inventory of raw materials: $15,000
 Direct labor: $40,000
 Manufacturing overhead: $73,000, including $3,000 of depreciation expense
 Selling and administrative expenses: $36,000, including depreciation expense of $1,000
 Interest expense: $5,000
 Principal payment on long term note: $20,000 each year
 Dividends declared: $20,000
 Income tax rate: 30%
Other information:

 Assume that there are no work-in-process or finished goods inventories.
 Year-end accounts receivable: 4% of 2022 sales.
 Year-end accounts payable: 50% of ending inventory of raw materials.
 Interest, direct labor, manufacturing overhead, and selling and administrative expenses other
than depreciation are paid as incurred.
 Dividends declared and income taxes for 2022 will not be paid until 2023.

Budget Inc.
Balance Sheet
31-Dec-21

Assets
Current assets
Cash $20,000
Raw materials inventory 10,000
Total current assets 30,000
Long term investment 88,000
Property, plant, and equipment
Equipment $40,000
Less: Accumulated depreciation 4,000 36,000
Total assets $154,000
Liabilities and Stockholders’ Equity
Liabilities
Accounts payable $5,000
Long-term notes payable 110,000
Total liabilities $115,000
Stockholders' equity
Common stock 25,000
Retained earnings 14,000
Total stockholders' equity 39,000
Total liabilities and stockholders'
equity $154,000
Isabella wants to prepare budgeted financial statements, but she needs some help.
Budget Inc. is considering an investment of $230,000 in new equipment. The new equipment is expected
to last ten years. It is estimated to have a zero salvage value at the end of its useful life. Budget Inc.
expects the same total net cash flows of $320,000 over the life of the investment. But, because of
declining market demand for the product over the life of the equipment, the net annual cash flows are
higher in the early years and lower in the later years, as below illustration:

Year Assumed Net Annual Cash Flows
1 60000
2 58000
3 45000
4 32000
5 28000
6 22000
7 21000
8 20000
9 19000
10 15000
320000

Isabella has to determine whether to add new equipment or not. The required return is 9% for Budget
Inc. Emily mentioned the critical of the loan from the Bank. Accepting the opportunity would mean an
immediate investment of $230,000 by Budget Inc. Those funds can be borrowed from the Bank at 5%
per annum. Isabella recalled the email from the bank manager as follows:

COVENANT COMPLIANCE

The undersigned certifies that they have not contravened any of the terms and conditions of the Bank's
credit facility pursuant to the Facility Letter and that they are in compliance with the following financial
covenants and the other conditions stipulated therein.

1. Total debt to tangible net worth ratio not to exceed 2.40 to 1.00. Actual ___________

2. Current ratio to be maintained at a minimum of 1.10. Actual ___________

The bank manager said the ratios could be based on the budgeted financial statement for 2022 without the new
equipment.

Isabella's new contract promises that she will receive, as a year-end bonus, 1% of all growth in Budget
Inc.'s pre-tax net income over the prior year. Hence, she is excited about expanding operations and
taking on the equipment. She is also wondering if specific accounting policies can be implemented to
increase income on paper, even if no significant changes are made in the business.

Help Isabella prepare a budgeted multiple-step income statement for the year ending December 31,
2022, and a budgeted classified balance sheet as of December 31, 2022.
Advise Isabella on her career path, and the current outlook on Budget Inc. Produce a business report,
including comprehensive analysis, recommendations, and any questions you may need to ask your
client.

Make the following:
1.Budgeted income statement
2. Budgeted cash flow
3. Accounting cash flow
4. Acceptance or rejection of new equipment

Answer rating: 100% (QA)

SOLUTION Beginning inventory 0 Purchases of Raw Materials 80000 Ending Inventory 15000 Direct Labor 40000 Manufacturing Overhead 73000 3000 Depreciation expense 70000 Formula Cost of Goods Sold Beginn... View the full answer