You have recently been hired by Bio Lux Company, in its relatively new treasury management department. Bio Lux was founded five years ago by Jessica Parker. Jessica found a method to produce high quality shampoo using natural ingredients. The shampoo produced by Bio Lux is in a good position to compete with other more established shampoo producers. The company is privately owned by Jessica Parker and her family, and it had sales of $12 million last year.
Bio Lux primarily sells its products through a wholesaler who distributes the products through its network of retailers throughout the country. Bio Lux’s growth to date has come from its innovation, quality, and low costs. When the company had sufficient capital, it would expand production. Relatively little formal analysis has been used in its capital budgeting process. Jessica has just read about capital budgeting techniques and has come to you for help. For starters, the company has never attempted to determine its cost of capital, and Jessica would like you to perform the analysis. Because the company is privately owned, it is difficult to determine the cost of equity for the company. Jessica wants you to use a similar company to estimate the cost of capital (WACC) for Bio Lux, and she has chosen Procter & Gamble as a representative company. The following questions will lead you through the steps to calculate this estimate.
1. To estimate the cost of equity for Procter & Gamble, go to finance.yahoo.com and enter the ticker symbol “PG.” Follow the various links at this website to find answers to the following questions:
a) What is the most recent stock price (and provide the associated date) listed for Procter & Gamble?
b) What is the market value of equity, or market capitalization?
c) How many shares of stock does Procter & Gamble have outstanding?
d) What is the beta for Procter & Gamble?
e) Now go back to finance.yahoo.com and follow the “Bonds” link. What is the yield on three-month Treasury bills? Using a 6 percent market risk premium, what is the cost of equity for Procter & Gamble using the CAPM?
In: Accounting
Requirements (Part one):Prepare an income statement for Petunia's Posies, a merchandiser, for the year ended December 31, 2016.
Part One: In 2015, Petunia Conway opened Petunia's Posies, a small retail shop selling floral arrangements
On December 31, 2016, her accounting records show the following:
|
Sales revenue. . . . . . . . . . . . . . . . |
$51,000 |
|
Utilities for shop. . . . . . . . . . . . . . |
$1,200 |
|
Inventory on December 31, 2016. . |
$9,900 |
|
Inventory on January 1, 2016. . . . . |
$12,600 |
|
Rent for shop. . . . . . . . . . . . . . . . |
$3,200 |
|
Sales commisions. . . . . . . . . . . . . |
$4,300 |
|
Purchases of merchandise. . . . . . |
$38,500 |
----------
Requirements (Part two):
|
1. |
Calculate the Cost of Goods Manufactured for
Floral Mart Manufacturing for the year ended December31,2017. |
|
2. |
Prepare an income statement for
Floral Mart Manufacturing for the year ended December 31,2017. |
|
3. |
How does the format of the income statement for
Floral Mart Manufacturing differ from the income statement ofPetunia's Posies? |
Part Two: Petunia's Posies was so successful that Petunia decided to manufacture her own brand of floral supplies: Floral Mart Manufacturing.
At the end of December 2017, her accounting records show thefollowing:
|
Utilities for plant. . . . . . . . . . . . . . . . . . . . . . . . . |
$5,100 |
|
Delivery expense. . . . . . . . . . . . . . . . . . . . . . . . |
$4,500 |
|
Sales salaries expense. . . . . . . . . . . . . . . . . . . . |
$5,000 |
|
Plant janitorial services. . . . . . . . . . . . . . . . . . |
$1,750 |
|
Work in process inventory, December 31, 2017. . . |
$5,500 |
|
Finished goods inventory, December 31, 2016. . . |
$0 |
|
Finished goods inventory, December 31, 2017. . . |
$2,000 |
|
Sales revenue. . . . . . . . . . . . . . . . . . . . . . . . . . |
$103,000 |
|
Customer service hotline expense. . . . . . . . . . . |
$1,800 |
|
Direct labor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . |
$27,000 |
|
Direct material purchases. . . . . . . . . . . . . . . . . . |
$39,000 |
|
Rent on manufacturing plant. . . . . . . . . . . . . . . . |
$8,200 |
|
Raw materials inventory, December 31, 2016. . . . |
$17,000 |
|
Raw materials inventory, December 31, 2017. . . . |
$8,500 |
|
Work in process inventory, December 31, 2016. . . |
$0 |
Part Three: Show the ending inventories that would appear on these balance sheets:
|
1. |
Petunia's Posies at December 31, 2016 |
|
2. |
Floral Mart Manufacturing at December 31, |
In: Accounting
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Direct labor $ 16.40 q Indirect labor $ 4,000 + $ 1.70 q Utilities $ 5,600 + $ 0.50 q Supplies $ 1,600 + $ 0.40 q Equipment depreciation $ 18,200 + $ 2.40 q Factory rent $ 8,400 Property taxes $ 2,900 Factory administration $ 13,100 + $ 0.80 q The actual costs incurred in March in the Production Department are listed below: Actual Cost Incurred in March Direct labor $ 72,120 Indirect labor $ 10,830 Utilities $ 8,240 Supplies $ 3,610 Equipment depreciation $ 28,520 Factory rent $ 8,800 Property taxes $ 2,900 Factory administration $ 15,930. Actual Labor Hours 44,300, and Budget Labor Hours 4,500
Required: 3. Complete the Production Department’s flexible budget performance report for March, including both the spending and activity variances.
In: Accounting
Explain how duties are segregated in payroll. Specifically, who or which departments conduct the authorization, timekeeping, recording, and custody functions?
In: Accounting
A shift in the sales mix from products with a low contribution margin ratio towards products with a high contribution margin ratio will lower the break even point in the company as a whole.
The answer is True. But why? Can this be proven with a numerical example?
In: Accounting
You have just started a new job with a significant increase in salary above what you were earning when you originally negotiated your student loan repayment. The salary increase affords you the opportunity of increasing your monthly loan payments, thereby allowing you to retire the debt sooner than originally planned. You have six years remaining in the original payback plan on a loan of $55,000, with an interest rate of 2.4% and a monthly payment of $566.74. With your new salary, you can afford a monthly payment of $672. You also will be eligible for end-of-year bonuses. PART 1: Use the concepts and techniques that you have learned throughout the semester to create a worksheet containing a loan calculator and an amortization schedule. Determine how soon you can retire the student loan debt with the new higher monthly payments. Assuming that you earn yearly bonuses of $6,000 at the end of each year, when could you pay off the remaining balance on your student loan if you kept the lower monthly payment? PART 2: Would you opt for increasing your monthly payment, or using any earned bonus money to retire the debt early? Explain the reason for your choice. PART 3: Create a PowerPoint presentation in which you summarize the spreadsheet and your decisions based on the spreadsheet. Choose your design, layout, font size, colors, and number of slides for the presentation. Please remember that PowerPoint is a visual and NOT a Word document. Considerations: Assume this is a fixed rate loan. Most loans do not penalize for pre-payment. In order to arrive at your answers, you will need to determine the following: A.Number of years for the original loan. There is a financial function that will help you obtain this information. To locate it, select the Formulas tab, click on Insert Function in the Function Library section. In the pop-up, type a brief description of what you want to do in the box provided, and then click Go. Once you select the appropriate function, specify the required parameters. B.Amortization schedule of the original loan. You will need to provide the Principal and Interest portion for each period (month). Follow the same steps specified in A above to locate the necessary functions. Please note that, as time goes on, the principal amount paid in each period (month) will increase while the interest amount paid will decrease. The principal portion plus the interest portion will always equal the total amount paid on each period (month). C.Amount of loan still owed. You can obtain this from the amortization table of the original loan and the information provided of the current period (month) of the loan. D.Period (month) on which you will complete paying the loan, based on the new payment amount. You may either develop an adjusted amortization schedule for the remaining payments, or find a function that provides the number of periods based on the remaining amount in the loan, the fixed interest rate, and the new monthly payments. Follow the same steps specified in A above to locate any functions you may need. E.Apply the annual bonus to the loan payments. Please follow prior steps to determine the impact of using your annual bonus to accelerate the payment of your loan.
In: Accounting
Why are some fixed assets susceptible to theft?
In: Accounting
Prepare a bank reconciliation for Blue Moon Company dated June 30, 2011 3.) Prepare any necessary journal entries based on the following data regarding the bank reconciliation prepared by Bootlegger Company on February 28, 2011. a) Outstanding cheques amount to $650. b) The service charges for February amount to $40. c) Cheque #665 for $3,525 for the cash purchase of office equipment was erroneously recorded by the bookkeeper as $3,552 d) The bank erroneously credited Bootlegger Company’s account for $300 for a deposit made by Bootlegger Company. e) A deposit ticket correctly prepared for $975 appeared on the bank statement as a deposit for $795 f) Cheque #650 for $100 for utilities expense was erroneously recorded by the bookkeeper as $10. g) A customer’s cheque for $250 was returned with the bank statement and stamped NSF. h) Bank balance on Feb.28 was $20,671 i) Cash account showed a balance of $20,254 on Feb. 28
In: Accounting
Calgary Paper Company produces paper for photocopiers. The company has developed standard overhead rates based on a monthly capacity of 80,000 direct-labor hours as follows:
| Standard costs per unit (one box of paper): | |||
| Variable overhead (3 direct-labor hours @ $4) | $ | 12 | |
| Fixed overhead (3 direct-labor hours @ $12) | 36 | ||
| Total | $ | 48 | |
During April, 26,000 units were scheduled for production: however, only 20,000 units were actually produced. The following data relate to April.
Actual direct-labor cost incurred was $1,425,000 for 75,000 actual hours of work.
Actual overhead incurred totaled $1,372,500, of which $472,500 was variable and $900,000 was fixed.
Required:
Prepare two exhibits similar to Exhibit 11-6 and Exhibit 11-8, which show the following variances. State whether each variance is favorable or unfavorable, where appropriate.
Variable-overhead spending variance.
Variable-overhead efficiency variance.
Fixed-overhead budget variance.
Fixed-overhead volume variance.
Variable-Overhead Spending and Efficiency Variances. (Select "None" and enter "0" for no effect (i.e., zero variance). Round "Actual Rate" and "Standard Rate" to 2 decimal places.)
| Variable-Overhead Spending And Efficiency Variances | |||||||||||||||||||
| (Hours = Direct-Labor Hours) | |||||||||||||||||||
| (1) | (2) | (3) | (4) | ||||||||||||||||
| Actual Variable Overhead | Projected Variable Overhead | Flexible Budget: Variable Overhead | Variable Overhead Applied To Work-In-Process | ||||||||||||||||
| Actual Qty (AQ) | × | Actual Rate (AVR) | Actual Qty (AQ) | × | Standard Rate (SVR) | Standard Allowed Qty (SQ) | × | Standard Rate (SVR) | Standard Allowed Qty (SQ) | × | Standard Rate (SVR) | ||||||||
| × | × | × | × | ||||||||||||||||
| hours | per hour | hours | per hour | hours | per hour | hours | per hour | ||||||||||||
| Variable-overhead spending variance | Variable-overhead efficiency variance | No difference | |||||||||||||||||
In: Accounting
How do audit committees provide balance? What issues may arise from them? What characteristics should a person on an audit committee have?
In: Accounting
On February 1, 2018, Wolf Inc. issued 10% bonds dated February 1, 2018, with a face amount of $200,000. The bonds sold for $239,588 and mature in 20 years. The effective interest rate for these bonds was 8%. Interest is paid semiannually on July 31 and January 31. Wolf's fiscal year is the calendar year. Wolf uses the effective interest method of amortization.
Required:
1. Prepare the journal entry to record the bond issuance on February 1, 2018.
2. Prepare the entry to record interest on July 31, 2018.
3. Prepare the necessary journal entry on December 31, 2018.
4. Prepare the necessary journal entry on January 31, 2019.
In: Accounting
Purple Company acquired 80 percent of Silver Company's outstanding common stock for $592,000 on January 1, 20X7. On the date of acquisition, the book value and fair value of Silver Company's net assets were equal. Purple Company uses the equity method to account for investments. Trial balance data for Purple and Silver as of January 1, 20X7 are as follows:
| Purple Company | Silver Company | |
|
Assets: Cash |
218,000 |
50,000 |
| Receivables | 130,000 | 74,000 |
| Inventory | 250,000 | 174,000 |
| Investment in Silver Company | 592,000 | |
| Land | 560,000 | 250,000 |
| Depreciable Assets | 1,750,000 | 500,000 |
| Accumulated Depreciation | -1,000,000 | -48,000 |
| Total Assets | 2,500,000 | 1 ,000,000 |
| Liabilities & Stockholders' Equity | ||
| Accounts Payable | 190,000 | 60,000 |
| Bonds Payable | 500,000 | 200,000 |
| Common Stock | 1,250,000 | 500,000 |
| Retained Earnings | 560,000 | 240,000 |
| Total Liabilities & Equity | 2,500,000 | 1,000,000 |
Immediately after acquisition, the consolidation worksheet was completed with all of the appropriate elimination entries (including pre-acquisition accumulated depreciation). The last column of the worksheet showing the consolidated totals has been left blank. Fill in the consolidated totals and identify the account marked with a "?" that will be included on the consolidated balance sheet.
In: Accounting
The City of Ashville operates an internal service fund to provide garage space and repairs for all city-owned-and-operated vehicles. The Central Garage Fund’s preclosing trial balance for the current fiscal year is as follows:
| Debits | Credits | |||||||||
| Cash | $ | 121,100 | ||||||||
| Due from Other Funds | 10,200 | |||||||||
| Inventory of Supplies | 99,000 | |||||||||
| Land | 54,500 | |||||||||
| Building | 275,500 | |||||||||
| Allowance for Depreciation—Building | $ | 22,100 | ||||||||
| Machinery and Equipment | 71,900 | |||||||||
| Allowance for Depreciation—Machinery and Equipment | 13,200 | |||||||||
| Vouchers Payable | 34,000 | |||||||||
| Net Position—Net Investment in Capital Assets | 366,600 | |||||||||
| Net Position—Unrestricted | 196,300 | |||||||||
| $ | 632,200 | $ | 632,200 | |||||||
The following information, not yet reflected in the preclosing figures above, applies to the current fiscal year:
| General Fund | $ | 297,000 | |
| Special Revenue Fund | 139,600 | ||
7. Unpaid interfund receivable balances were as follows:
| Beginning of Year | End of Year | |||||||
| General Fund | $ | 2,800 | $ | 3,300 | ||||
| Special Revenue Fund | 7,400 | 10,200 | ||||||
8. Vouchers payable at year-end were $17,500.
9. Closing entries were prepared for the Central Garage Fund (ignore government-wide closing entry).
Prepare a statement of revenues, expenses, and changes in fund net position for the Central Garage Fund for the period.
In: Accounting
Think about someone you know has thought about having a business. It does not matter a recent thing or a long time ago. The important thing is that you need to identify the following: 1. Do a SWAT analysis for the person's idea ( or your idea) 2. Define the Business Model and target market. 3. Do an analysis of the person (entrepreneur's) personality in relation to commitment, and all the qualities that may be key to take one's ideas to reality. 4. With this information do a recommendation for this idea from the view point of a "Small Business Consultant"stating first steps to follow and value proposition of your services to coach someone through grounding their ideas. Minimum 5 pages.
In: Accounting
Analyzing, Forecasting, and Interpreting Both Income Statement
and Balance Sheet
Following are the income statements and balance sheets of General
Mills, Inc.
| Income Statement, Fiscal Years Ended ($ millions) |
May 29, 2011 | May 30, 2010 |
|---|---|---|
| Net Sales | $ 14,880.2 | $ 14,635.6 |
| Cost of sales | 8,926.7 | 8,835.4 |
| Selling, general and administrative expenses | 3,192.0 | 3,162.7 |
| Divestitures (gain), net | (17.4) | -- |
| Restructuring, impairment, and other exit costs | 4.4 | 31.4 |
| Operating income | 2,774.5 | 2,606.1 |
| Interest, net | 346.3 | 401.6 |
| Earnings before income tax expense and equity in income of affiliates | 2,428.2 | 2,204.5 |
| Income tax expense | 721.1 | 771.2 |
| After-tax earnings from joint ventures | 96.4 | 101.7 |
| Net earnings including noncontrolling interests | 1,803.5 | 1,535.0 |
| Net earnings attributable to noncontrolling interests | 5.2 | 4.5 |
| Net earnings attributable to General Mills | $ 1,798.3 | $ 1,530.5 |
| Balance Sheet ($ millions) |
May 29, 2011 | May 30, 2010 |
|---|---|---|
| Assets | ||
| Cash and cash equivalents | $ 619.6 | $ 673.2 |
| Receivables | 1,162.3 | 1,041.6 |
| Inventories | 1,609.3 | 1,344.0 |
| Deferred income taxes | 27.3 | 42.7 |
| Prepaid expenses and other current assets | 483.5 | 378.5 |
| Total current assets | 3,902.0 | 3,480.0 |
| Land, buildings and equipment | 3,345.9 | 3,127.7 |
| Goodwill | 6,750.8 | 6,592.8 |
| Other intangible assets | 3,813.3 | 3,715.0 |
| Other assets | 862.5 | 763.4 |
| Total assets | $ 18,674.5 | $ 17,678.9 |
| Liabilities and Equity | ||
| Accounts payable | $ 995.1 | $ 849.5 |
| Current portion of long-term debt | 1,031.3 | 107.3 |
| Notes payable | 311.3 | 1,050.1 |
| Other current liabilities | 1,321.5 | 1,762.2 |
| Total current liabilities | 3,659.2 | 3,769.1 |
| Long-term debt | 5,542.5 | 5,268.5 |
| Deferred income taxes | 1,127.4 | 874.6 |
| Other liabilities | 1,733.2 | 2,118.7 |
| Total liabilities | 12,062.3 | 12,030.9 |
| Stockholders' equity | ||
| Common stock, 754.6 shares issued, $0.10 par value | 75.5 | 75.5 |
| Additional paid-in capital | 1,319.8 | 1,307.1 |
| Retained earnings | 9,191.3 | 8,122.4 |
| Common stock in treasury, at cost, shares of 109.8 and 98.1 | (3,210.3) | (2,615.2) |
| Accumulated other comprehensive loss | (1,010.8) | (1,486.9) |
| Total shareholders' equity | 6,365.5 | 5,402.9 |
| Noncontrolling interests | 246.7 | 245.1 |
| Total equity | 6,612.2 | 5,648.0 |
| Total Liabilities and Equity | $ 18,674.5 | $ 17,678.9 |
Forecast General Mill's fiscal 2012 income statement using the following relations (assume "no change" for accounts not listed). Assume that depreciation and amortization expense is included as part of selling, general and administrative expense ($ millions).
| Net sales growth | 4.0% |
| Cost of sales/Net sales | 60.0% |
| Selling, general and administrative expenses/Net sales | 21.5% |
| Divestitures (gain), net | $-- |
| Restructuring, impairment, and other exit costs | $-- |
| Interest, net | $346.3 |
| Income tax expense/Pretax income | 29.7% |
| After-tax earnings from joint ventures | $96.4 |
| Net earnings attributable to noncontrolling interests/Net earnings before attribution | 0.5% |
Round answers one decimal place.
Do not use negative signs with your answers.
| Income Statement, Fiscal Years Ended ($ millions) | 2012 Estimated |
|---|---|
| Net sales | $Answer
Correct |
| Cost of goods sold | Answer
Correct |
| Selling, general and administrative expenses | Answer
Correct |
| Divestitures (gain), net | Answer
Correct |
| Restructuring, impairment, and other exit costs | Answer
Correct |
| Operating income | Answer
Correct |
| Interest expense | Answer
Correct |
| Earnings before income tax expense and equity in income of affiliates | Answer
Correct |
| Income tax expense | Answer
Correct |
| Equity in income of affiliates | Answer
Correct |
| Net earnings including noncontrolling interests | Answer
Correct |
| Net earnings attributable to noncontrolling interests | Answer
Correct |
| Net earnings attributable to General Mills | $Answer
Correct |
Forecast General Mill's fiscal 2012 balance sheet using the following relations (assume "no change" for accounts not listed). Assume that all capital expenditures are purchases of land, building and equipment, net. ($ millions).
| Receivables/Net sales | 7.8% |
| Inventories/Net sales | 10.8% |
| Deferred income tax/Net sales | 0.2% |
| Prepaid expenses and other current assets/Net sales | 3.2% |
| Other intangible assets | $0 amortization |
| Other Assets/Net sales | 5.8% |
| Accounts payable/Net sales | 6.7% |
| Other current liabilities/Net sales | 8.9% |
| Current portion of long-term debt | $733.6 |
| Deferred income taxes/Net sales | 7.6% |
| Other liabilities/Net sales | 11.6% |
| Noncontrolling interests | * |
| Capital expenditures/Net sales | 4.4% |
| Depreciation/Prior year net PPE | 20.7% |
| Dividends/Net income | 40.6% |
| Current maturities of long-term debt in fiscal 2013 | $733.6 |
| *increase by net income attributable to noncontrolling interests and assume no dividends |
Round answers one decimal place.
Do not use negative signs with your answers.
| Balance Sheet ($ millions) |
2012 Estimated |
|---|---|
| Assets | |
| Cash and cash equivalents | $Answer
Incorrect |
| Receivables | Answer
Correct |
| Inventories | Answer
Correct |
| Deferred income taxes | Answer
Correct |
| Prepaid expenses and other | Answer
Correct |
| Total current assets | Answer
Incorrect |
| Land, buildings, and equipment | Answer
Incorrect |
| Goodwill | Answer
Incorrect |
| Other intangible assets | Answer
Incorrect |
| Other assets | Answer
Correct |
| Total assets | $Answer
Incorrect |
| Liabilities and equity | |
| Accounts payable | $Answer
Correct |
| Current portion of long-term debt | Answer
Correct |
| Notes payable | Answer
Incorrect |
| Other current liabilities | Answer
Correct |
| Total current liabilities | Answer
Incorrect |
| Total long-term debt | Answer
Incorrect |
| Deferred income taxes | Answer
Correct |
| Other liabilities | Answer
Correct |
| Total liabilities | Answer
Incorrect |
| Stockholders equity | |
| Common stock | Answer
Incorrect |
| Additional paid-in capital | Answer
Incorrect |
| Retained earnings | Answer
Incorrect |
| Common stock in treasury | Answer
Incorrect |
| Accumulated other comprehensive loss | Answer
Incorrect |
| Total shareholders' equity | Answer
Incorrect |
| Noncontrolling interests | Answer
Incorrect |
| Total equity | Answer
Incorrect |
| Total liabilities and Equity | $ Answer
Incorrect |
In: Accounting