Question

In: Accounting

Chapter 5 Case You are the Chief Financial Officer (CFO) for Zen Distributors Inc., a media...

Chapter 5 Case

You are the Chief Financial Officer (CFO) for Zen Distributors Inc., a media broker that secure shelf space in independent bookstores for small publishing companies. As a member of the company’s executive team, you are preparing the operating budget for the fourth quarter of 2020. Your intent is to summarize the budget for team members and provide them with detailed schedules that support your overview.  

Zen’s general ledger provides you with current account data on September 30, 2020 (the end of the third quarter) of operations:

Accounts (account amounts in thousands of dollars)

Debit

Credit

Cash

$    8,000

Accounts receivable

    20,000

Inventory

    36,000

Buildings and equipment, net of depreciation

120,000

Accounts payable

$ 21,750

Common stock

150,000

Retained earnings

    12,250

    Totals

$184,000

$184,000

Jack Closer, Vice President of Sales, estimated that sales should increase slightly from their fourth quarter levels of the previous year. Per your request, he forwarded his monthly fourth quarter sales estimates to you, along with the current month’s actual sales and his forecast for January 2021.

Month

Sales

September 2020 (actual)

$ 50,000

October 2020

    60,000

November 2020

    72,000

December 2020

    90,000

January 2021

    48,000

You next met with Mary Balance, Zen’s Controller. Ms. Balance informed you that the company prices its products to ensure a 25% gross profit margin on sales. Zen has met that margin throughout the first three quarters of 2020, and she was confident that the firm would meet this target margin in the near term. Mary also told you that, on average, 60% of Zen’s customer pay in cash. Those customers receive a one percent discount on the invoice price.

The remaining 40% of the customers pay on account. Credit sales terms are n/2EOM. This means credit customers must pay the full invoice price by the end of the month following the month in which they purchased merchandise. Mary explained, “Our customers are pretty sophisticated, and they constantly manage their cash flows--just as we do. Consequently, if we make a credit sale in October, they will pay us by the end of November.” Finally, Mary said, “We screen our customers very carefully before extending them credit. Our customers pay what they owe us. We don’t have any bad debts, and we don’t expect any in the future.”  

Mary also provided you with third quarter monthly expense data to assist in constructing your budget. The next table presents that information:

Monthly Expense Item

Amount

Administration

$2,500

General

6% of sales

Commissions

12% of sales

Depreciation

$850

She concluded that, “As you know, we pay our operating expenses in the month we accrue them.”

               Procurement officer Jim Washburn managed inventory so that its ending balance equaled 80% of the next month’s cost of goods sold. Washburn said, “We can construct monthly purchase budgets as follows: add desired ending inventory to cost of goods sold, which are 75% of sales, to determine required inventory for a month. Then we subtract that month’s beginning inventory to determine required purchases for the month.” Washburn also stated that the accounts payable clerk pays one-half of each month’s inventory cost in the month of acquisition, and the remaining 50% in the following month.

               Ashleigh McNamara, head of capital expenditures, informed you that Zen will make a cash purchase of $1,500 worth of hand-held scanning devices in early October. McNamara said “We will use operating cash to pay for the scanners because they are an inexpensive capital acquisition.” Per corporate policy, the firm will depreciate this equipment over thirty months on a straight-line basis. Ashleigh added, “They’ll be useless at the end of that time, so we will scrap them.”    

               In your role as CFO, you insist that Zen maintain an ending monthly cash balance of $4,000 to maintain financial flexibility. The company has an open line of credit with its banking partner to ensure that it can meet its cash balance goal. This agreement mandates a 12% annual interest rate for all short-term borrowings. Financing must take place at the beginning of the month in thousand dollar multiples. Repayments of borrowing must also occur in thousand dollar increments, and the bank only accepts interest payments when Zen repays principal.    

Required:

Compose a memorandum to Zen’s management team that highlights the key aspects of the 2020 fourth quarter operating budget. Supplement your summary with budgetary schedules and attach them to the executive summary. The budgetary flow that you select is as follows:

  • Cash collections

  • Inventory purchases

  • Cash disbursements for purchases

  • Cash disbursements for operating expenses

  • Short-term financing budget (collections, disbursements, and financing)

You construct each of the above budgets on a monthly and quarterly basis.

               Finally, you conclude your budgets with projected (pro-forma) monthly and quarterly income statements and a pro-forma balance sheet on December 31. The company has a zero percent income tax rate, due to previous tax losses.  

Solutions

Expert Solution


Related Solutions

Continuing in your role as the Chief Financial Officer (CFO) of Anycorp Inc., you are interested...
Continuing in your role as the Chief Financial Officer (CFO) of Anycorp Inc., you are interested in looking at the various financing options for the acquisition of Anycorp's defeated rival, Initech LLC. While your last inspection of financing options centered around debt financing, you're now interested in examining acquisition financing using equity (read: stock) financing. As in the prior case analysis and based on your readings from Chapter 7, prepare an Executive Summary discussing the various pros, cons, and tradeoffs...
You are a Financial Analyst with ABC Ltd and the chief financial officer (CFO) requests you...
You are a Financial Analyst with ABC Ltd and the chief financial officer (CFO) requests you to evaluate two new capital budgeting proposals. Specifically, you are asked to provide a recommendation and also respond to a number of questions aimed at assessing your level of competence in capital budgeting process. Instructions are as follows: Provide an evaluation of two proposed projects, both with identical initial outlays of $400,000. Both of these projects involve additions to a client’s highly successful product...
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of...
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of your chosen company that summarizes the audit process conducted. Then, you will assume the role of CFO of the company and prepare a memo to the Board of Directors as to what potential issues the external audit team might find and what the company's response should be.
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of...
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of your chosen company that summarizes the audit process conducted. Then, you will assume the role of CFO of the company and prepare a memo to the Board of Directors as to what potential issues the external audit team might find and what the company's response should be.
You are the chief financial officer (CFO) for an organization and need to discuss with fellow...
You are the chief financial officer (CFO) for an organization and need to discuss with fellow C-suite executives that cost cutting is not the only answer to profitability. Prepare for the next manager's meeting by responding to the following prompts: ·Explain how a capital budget and a return on investment contribute to sustainable growth. ·Clarify the role that risk analysis plays during capital investment decision making.
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary this year. Your chief executive officer (CEO) has requested a presentation to the board of directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the board and support your recommendation with examples. Respond to...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary this year. Your chief executive officer (CEO) has requested a presentation to the board of directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the board and support your recommendation with examples. Respond to...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary during the current year. Your chief executive officer (CEO) has requested a presentation to the Board of Directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the Board and support your recommendation with examples....
Instructions: You are the Chief Financial Officer (CFO) of a firm that is being sued for...
Instructions: You are the Chief Financial Officer (CFO) of a firm that is being sued for damages it caused. It is the end of your fiscal year, and you are trying to determine the appropriate treatment of this matter. Your boss, the Chief Executive Officer (CEO) acknowledges (privately) that your firm is responsible for the damages and that the judgment will be made against your firm. Your legal counsel estimates that the penalty levied by the court will be in...
Peter Krone is the chief financial officer (CFO) of Echo Inc. The firm was founded seven...
Peter Krone is the chief financial officer (CFO) of Echo Inc. The firm was founded seven years ago to provide educational services for the rapidly expanding primary and secondary school markets. Although Echo Inc. has done well, the firm's founder believes that an industry shakeout is imminent. To survive, Echo Inc. must grab market share now, and this will require a large infusion of new capital. Because he expects earnings to continue rising sharply and looks for the stock price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT