Financial Statement Analysis
Due Date: Monday, March 18, 2019 by 5:00pm.
Submission:
Upload your submission file to D2L under Assignments. Include your
first and last name in the title of the files you upload. Each
individual will submit one (1) Excel workbook and one (1) Word
document. There should be only one (1) worksheet in the
workbook.
Donna James, a 2009 graduate of the University of Florida with 4 years of banking experience, was recently brought in as an assistant to the chairperson of the board of Keystone Foods, a small food producer that operates in southeastern Pennsylvania and whose specialty is high-quality pecan and other nut products sold in the snack food market. Keystone’s president, Jimmy Watkins, decided in 2017 to undertake a major expansion and to “go national” in competition with Frito-Lay, Eagle, and other major snack food companies. Watkins believed that Keystone’s products were of higher quality than the competition’s; that this quality differential would enable it to charge a premium price; and that the end results would be greatly increased sales, profits, and stock price.
The company doubled its plant capacity, opened new sales offices outside its home territory, and launched an expensive advertising campaign. Keystone’s results were not satisfactory, to put it mildly. Thus far, sales have not been up to the forecasted level, costs have been higher than were projected, and a large loss occurred in 2018 rather than the expected profit.
Its board of directors, which consisted of the president, vice president, and major stockholders (all of whom were local business people), was most upset when directors learned how the expansion was going. Unhappy suppliers were being paid late; and the bank was complaining about the deteriorating situation, threatening to cut off credit. As a result, Watkins was informed that changes would have to be made - and quickly; otherwise, he would be fired. Also, at the board’s insistence, Donna James was brought in and given the job of assistant to Frederico Ortez, a retired banker who was Keystone’s chairperson and largest stockholder. Ortez agreed to give up a few of his golfing days and help nurse the company back to health, with James’ help.
James began by gathering the financial statements and other data given (see supplemental spreadsheet schedules). She also projected financial statement data for 2019 (see supplemental spreadsheet schedules), assuming that some new financing is arranged to get the company “over the hump.”
James examined monthly data for 2018 (not provided in the case), and she detected an improving pattern during the year. Monthly sales were rising, costs were falling, and large losses in the early months had turned to a small profit by December. Thus, the annual data look somewhat worse than final monthly data. Also, she noticed that it appears to be taking longer for the advertising program to get the message out, for the new sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other words, the lags between spending money and deriving benefits were longer than Keystone’s managers had anticipated. For these reasons, James and Ortez see hope for the company - provided it can survive in the short run.
Other pertinent facts:
Keystone purchases materials on 30-day terms, meaning that it is supposed to pay for purchases within 30 days of receipt.
Keystone spends money for labor, materials, and fixed (long-term) assets (i.e., depreciation) to make products - and spends still more money to sell those products. Then, the firm makes sales that result in receivables, which eventually results in cash inflows.
Keystone’s sales manager changed the company’s sales terms to 60-day credit terms rather than 30-day terms which were historically offered. Keystone’s competitors reacted by offering similar terms.
James must prepare an analysis of where the company is now, what it must do to regain its financial health, and what actions should be taken. Your assignment is to help her answer the following questions. Using spreadsheet software (i.e., Microsoft Excel or Google Sheets) and word processing software (i.e., Microsoft Word or Google Docs), respond to the following items, providing clear explanations, not simply “yes” or “no” answers. In all cases requiring computation, determine your responses using appropriate formulas. DO NOT simply key in an answer without computation.
Identify specific ratios that should be used to assess the financial health of Keystone. Justify your inclusion of each selected ratio. Be sure to also classify these ratios based on what aspect of the firm’s characteristics they reflect (e.g., liquidity).
For each given year, conduct calculations for the ratios you identified in #1. Show the appropriate formula for each ratio, the value(s) used in the numerator and denominator, and the final calculated result.
Discuss/interpret each ratio in the context of the company’s overall financial health. Which ratios are positive and/or show improvement? Which ratios continue to highlight areas for further investigation or problems? Discuss any trends in the ratios that you observed over the time period presented.
Based on your analysis, what three (or more) specific actionable items could Keystone do to improve its financial health? Be specific in your response and discuss the implication of your recommendation; for example, if you suggest that the company should pursue raising capital through a bond issue, you should discuss the merits of this recommendation, note any limitations that the company may encounter, and discuss the expected implication on the firm’s financial results. On the later, a high-level discussion on the financial results will suffice, such as, “if a bond issue is undertaken, the company would be responsible for paying bond interest expense which would negatively affect cash flow.
In: Accounting
On January 1, 2017, Boston Enterprises issues bonds that have a $1,600,000 par value, mature in 20 years, and pay 8% interest semiannually on June 30 and December 31. The bonds are sold at par.
1. How much interest will Boston pay (in cash) to the bondholders every six months?
2. Prepare journal entries to record (a) the issuance of bonds on January 1, 2017; (b) the first interest payment on June 30, 2017; and (c) the second interest payment on December 31, 2017.
3. Prepare the journal entry for issuance assuming the bonds are issued at (a) 98 and (b) 102.
In: Accounting
In: Accounting
Lone Star Sales & Service acquired a new machine that cost
$84,000 in early 2016. The machine is expected to have a five-year
useful life and is estimated to have a salvage value of $14,000 at
the end of its life. (Round your final answers to the nearest
dollar.)
(a.) Using the straight-line depreciation method, calculate the
depreciation expense to be recognized in the second year of the
machine's life and calculate the accumulated depreciation after the
third year of the machine's life.
(b.) Using the double-declining-balance depreciation method,
calculate the depreciation expense for the third year of the
machine's life and the net book value of the machine at this point
in time.
In: Accounting
The management team of U. Dunnit Limited have four projects for consideration. In the past, they have evaluated projects
against simple payback. The following information is available:
Project A Project B Project C Project D £
| A | B | C | D | |
| Capital Outlay | 65,000 | 140,000 | 30,000 | 160,000 |
| Net Cash Inflow | ||||
| Year 1 | 30,000 | 45,000 | 20,000 | 35,000 |
| Year 2 | 20,000 | 45,000 | 10,000 | 35,000 |
| Year 3 | 15,000 | 45,000 | 10,000 | 55,000 |
| Year 4 | 10,000 | 45,000 | 55,000 | |
| Year 5 | 10,0000 | 45,000 | 65,000 |
REQUIRED
Evaluate the projects using each of the following methods:
(a) Payback.
(b) Accounting rate of return using full capital outlay (investment).
(c) Net present value and profitability index. Assuming a cost of capital of 6%.
In: Accounting
Warnerwoods Company uses a periodic inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 195 | units | @ $85 per unit | |||||||
| Mar. | 5 | Purchase | 495 | units | @ $90 per unit | |||||||
| Mar. | 9 | Sales | 515 | units | @ $120 per unit | |||||||
| Mar. | 18 | Purchase | 310 | units | @ $95 per unit | |||||||
| Mar. | 25 | Purchase | 390 | units | @ $97 per unit | |||||||
| Mar. | 29 | Sales | 350 | units | @ $130 per unit | |||||||
| Totals | 1,390 | units | 865 | units | ||||||||
For specific identification, the March 9 sale consisted of 60 units from beginning inventory and 455 units from the March 5 purchase; the March 29 sale consisted of 135 units from the March 18 purchase and 215 units from the March 25 purchase.
3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. (Round your average cost per unit to 2 decimal places
In: Accounting
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled:
| Month | Rental Returns | Car Wash Costs | |||
| January | 2,500 | $ | 12,100 | ||
| February | 2,600 | $ | 13,700 | ||
| March | 2,800 | $ | 12,900 | ||
| April | 3,200 | $ | 15,900 | ||
| May | 3,700 | $ | 17,300 | ||
| June | 5,300 | $ | 25,500 | ||
| July | 5,600 | $ | 23,300 | ||
| August | 5,800 | $ | 24,900 | ||
| September | 4,800 | $ | 23,900 | ||
| October | 5,200 | $ | 24,400 | ||
| November | 2,300 | $ | 11,800 | ||
| December | 3,200 | $ | 18,100 | ||
Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places.)
In: Accounting
Warnerwoods Company uses a periodic inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 195 | units | @ $85 per unit | |||||||
| Mar. | 5 | Purchase | 495 | units | @ $90 per unit | |||||||
| Mar. | 9 | Sales | 515 | units | @ $120 per unit | |||||||
| Mar. | 18 | Purchase | 310 | units | @ $95 per unit | |||||||
| Mar. | 25 | Purchase | 390 | units | @ $97 per unit | |||||||
| Mar. | 29 | Sales | 350 | units | @ $130 per unit | |||||||
| Totals | 1,390 | units | 865 | units | ||||||||
For specific identification, the March 9 sale consisted of 60 units from beginning inventory and 455 units from the March 5 purchase; the March 29 sale consisted of 135 units from the March 18 purchase and 215 units from the March 25 purchase.
4. Compute gross profit earned by the company for each of the four costing methods. (Round your average cost per unit to 2 decimal places and final answers to nearest whole dollar.)
In: Accounting
Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The company's materials and parts manager is currently revising the inventory policy for XL-20, one of the chemicals used in the production process. The chemical is purchased in 10-pound canisters for $107 each. The firm uses 6,000 canisters per year. The controller estimates that it costs $162 to place and receive a typical order of XL-20. The annual cost of storing XL-20 is $5.20 per canister.
Required:
Use the EOQ formula to determine the optimal order quantity.
What is the total annual cost of ordering and storing XL-20 at the economic order quantity?
How many orders will be placed per year?
Fiber Technology’s controller, Jay Turnbull, recently attended a seminar on JIT purchasing. Afterward he analyzed the cost of storing XL-20, including the costs of wasted space and inefficiency. He was shocked when he concluded that the real annual holding cost was $31.20 per canister. Turnbull then met with Doug Kaplan, Fiber Technology’s purchasing manager. Together they contacted Reno Industries, the supplier of XL-20, about a JIT purchasing arrangement. After some discussion and negotiation, Kaplan concluded that the cost of placing an order for XL-20 could be reduced to just $32. Using these new cost estimates, Turnbull computed the new EOQ for XL-20 a. Use the equation approach to compute the new EOQ.b. How many orders will be placed per year?
1.Use the EOQ formula to determine the optimal order quantity. (Round your answer to nearest whole number.)
2.What is the total annual cost of ordering and storing XL-20 at the economic order quantity? (Round intermediate calculations and final answer to nearest whole number.)
3.How many orders will be placed per year? (Round intermediate calculations and final answer to nearest whole number.)
4. Fiber Technology’s controller, Jay Turnbull, recently
attended a seminar on JIT purchasing. Afterward he analyzed the
cost of storing XL-20, including the costs of wasted space and
inefficiency. He was shocked when he concluded that the real annual
holding cost was $31.20 per canister. Turnbull then met with Doug
Kaplan, Fiber Technology’s purchasing manager. Together they
contacted Reno Industries, the supplier of XL-20, about a JIT
purchasing arrangement. After some discussion and negotiation,
Kaplan concluded that the cost of placing an order for XL-20 could
be reduced to just $32.00. Using these new cost estimates, Turnbull
computed the new EOQ for XL-20.
a. Use the equation approach to compute the new EOQ. (Round your
answer to nearest whole number.)
b. How many orders will be placed per year? (Round your answer to
nearest whole number.)
In: Accounting
Warnerwoods Company uses a perpetual inventory system. It
entered into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 200 | units | @ $53.00 per unit | |||||||
| Mar. | 5 | Purchase | 275 | units | @ $58.00 per unit | |||||||
| Mar. | 9 | Sales | 360 | units | @ $88.00 per unit | |||||||
| Mar. | 18 | Purchase | 135 | units | @ $63.00 per unit | |||||||
| Mar. | 25 | Purchase | 250 | units | @ $65.00 per unit | |||||||
| Mar. | 29 | Sales | 230 | units | @ $98.00 per unit | |||||||
| Totals | 860 | units | 590 | units | ||||||||
4. Compute gross profit earned by the company
for each of the four costing methods. For specific identification,
the March 9 sale consisted of 115 units from beginning inventory
and 245 units from the March 5 purchase; the March 29 sale
consisted of 95 units from the March 18 purchase and 135 units from
the March 25 purchase. (Round weighted average cost per
unit to two decimals and final answers to nearest whole
dollar.)
In: Accounting
The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
| Maine: | |
| Backyard Chef | 310 units at $700 per unit |
| Master Chef | 150 units at $1,200 per unit |
| Vermont: | |
| Backyard Chef | 240 units at $750 per unit |
| Master Chef | 110 units at $1,300 per unit |
| New Hampshire: | |
| Backyard Chef | 360 units at $750 per unit |
| Master Chef | 180 units at $1,400 per unit |
b. Estimated inventories at July 1:
| Direct materials: | |
| Grates | 290 units |
| Stainless steel | 1,500 lbs. |
| Burner subassemblies | 170 units |
| Shelves | 340 units |
| Finished products: | |
| Backyard Chef | 30 units |
| Master Chef | 32 units |
c. Desired inventories at July 31:
| Direct materials: | |
| Grates | 340 units |
| Stainless steel | 1,800 lbs. |
| Burner subassemblies | 155 units |
| Shelves | 315 units |
| Finished products: | |
| Backyard Chef | 40 units |
| Master Chef | 22 units |
d. Direct materials used in production:
| In manufacture of Backyard Chef: | |
| Grates | 3 units per unit of product |
| Stainless steel | 24 lbs. per unit of product |
| Burner subassemblies | 2 units per unit of product |
| Shelves | 4 units per unit of product |
| In manufacture of Master Chef: | |
| Grates | 6 units per unit of product |
| Stainless steel | 42 lbs. per unit of product |
| Burner subassemblies | 4 units per unit of product |
| Shelves | 5 units per unit of product |
e. Anticipated purchase price for direct materials:
| Grates | $15 per unit |
| Stainless steel | $6 per lb. |
| Burner subassemblies | $110 per unit |
| Shelves | $10 per unit |
f. Direct labor requirements:
| Backyard Chef: | |
| Stamping Department | 0.50 hr. at $17 per hr. |
| Forming Department | 0.60 hr. at $15 per hr. |
| Assembly Department | 1.00 hr. at $14 per hr. |
| Master Chef: | |
| Stamping Department | 0.60 hr. at $17 per hr. |
| Forming Department | 0.80 hr. at $15 per hr. |
| Assembly Department | 1.50 hrs. at $14 per hr. |
Required:
1. Prepare a sales budget for July.
| Gourmet Grill Company Sales Budget For the Month Ending July 31 |
||||
|---|---|---|---|---|
| Product and Area | Unit Sales Volume |
Unit Selling Price |
Total Sales | |
| Backyard Chef: | ||||
| Maine | $ | $ | ||
| Vermont | ||||
| New Hampshire | ||||
| Total | $ | |||
| Master Chef: | ||||
| Maine | $ | $ | ||
| Vermont | ||||
| New Hampshire | ||||
| Total | $ | |||
| Total revenue from sales | $ | |||
2. Prepare a production budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
| Gourmet Grill Company Production Budget For the Month Ending July 31 |
||
|---|---|---|
| Units | ||
| Backyard Chef | Master Chef | |
3. Prepare a direct materials purchases budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
| Gourmet Grill Company Direct Materials Purchases Budget For the Month Ending July 31 |
|||||
|---|---|---|---|---|---|
| Grates (units) |
Stainless Steel (lbs.) |
Burner Sub- assemblies (units) |
Shelves (units) |
Total | |
| Required units for production: | |||||
| Backyard Chef | |||||
| Master Chef | |||||
| Desired inventory, July 31 | |||||
| Total | |||||
| Estimated inventory, July 1 | |||||
| Total units to be purchased | |||||
| Unit price | $ | $ | $ | $ | |
| Total direct materials to be purchased | $ | $ | $ | $ | $ |
4. Prepare a direct labor cost budget for July.
| Gourmet Grill Company Direct Labor Cost Budget For the Month Ending July 31 |
||||||||
|---|---|---|---|---|---|---|---|---|
| Stamping Department |
Forming Department | Assembly Department | Total | |||||
| Hours required for production: | ||||||||
| Backyard Chef | ||||||||
| Master Chef | ||||||||
| Total | ||||||||
| Hourly rate | $ | $ | $ | |||||
| Total direct labor cost | $ | $ | $ | $ | ||||
In: Accounting
You are a real estate owner in Bloomington Indiana and you have rented a house to students. You expect to make 6% per year on this leasehold investment. The terms of the lease are for 24 months and the rent is due at the beginning of the month. Your savvy renters are Kelley students and they request that the rent be paid, instead, at the end of the month. How much more will the investor receive as a result of payments at the beginning of the month rather than the student's proposed payments at the end of the month over the entire life of the lease? The monthly rent payment is $2800.
a. $1800
b. $162.67
c. $2108.46
d. $315.88
e. $1408.49
In: Accounting
Danos Company’s partial worksheet for the month ended December
31, 2019, is shown below. Open the owner’s capital account (account
number 301) in the general ledger and record the December 1, 2019,
balance of $77,000 shown on the worksheet.
| INCOME STATEMENT | BALANCE SHEET | |||||||
| ACCOUNT NAME | DEBIT | CREDIT | DEBIT | CREDIT | ||||
| Cash | 23,500 | |||||||
| Accounts Receivable | 24,600 | |||||||
| Supplies | 10,300 | |||||||
| Equipment | 66,500 | |||||||
| Accum. Depr. - Equip. | 22,600 | |||||||
| Accounts Payable | 20,300 | |||||||
| D. Danos, Capital | 77,000 | |||||||
| D. Danos, Drawing | 7,300 | |||||||
| Fees Income | 53,800 | |||||||
| Salaries Expense | 29,400 | |||||||
| Rent Expense | 4,100 | |||||||
| Supplies Expense | 2,050 | |||||||
| Depr. Exp. −Equip. | 5,950 | |||||||
| Totals | 41,500 | 53,800 | 132,200 | 119,900 | ||||
| Net Income | 12,300 | 12,300 | ||||||
| 53,800 | 53,800 | 132,200 | 132,200 | |||||
Prepare the closing entries for the Danos Company’s on December 31,
2019. Post the closing entries to the owner’s capital account.
Prepare a postclosing trial balance.
In: Accounting
Lynch Company manufactures and sells a single product. The following costs were incurred during the company’s first year of operations:
| Variable costs per unit: | ||
| Manufacturing: | ||
| Direct materials | $ | 10 |
| Direct labor | $ | 4 |
| Variable manufacturing overhead | $ | 1 |
| Variable selling and administrative | $ | 1 |
| Fixed costs per year: | ||
| Fixed manufacturing overhead | $ | 231,000 |
| Fixed selling and administrative | $ | 141,000 |
During the year, the company produced 21,000 units and sold 17,000 units. The selling price of the company’s product is $40 per unit.
Required:
1. Assume that the company uses absorption costing:
a. Compute the unit product cost.
b. Prepare an income statement for the year.
2. Assume that the company uses variable costing:
a. Compute the unit product cost.
b. Prepare an income statement for the year.
In: Accounting
A company sells personal computeres. The price includes a two-year warranty. During 2016, the company made $920,000 in sales. On the basis of past experience, the warranty costs are estimated to be 10% of sales. One customer brought in their computer on January 10, 2017 which required warranty repairs of $200 taken from parts taken from the Repair Parts Inventory. Prepare general journal entries to record: a. the estimated warranty expense on December 31, 2016. b. The warranty repair costs
In: Accounting