Showing posts with label following. Show all posts
Showing posts with label following. Show all posts

P12-4A On January 1, 2008, Galactica Corporation had the following stockholders’ equity


accounts.



Common Stock ($20 par value, 60,000 shares issued and



outstanding) $1,200,000



Paid-in Capital in Excess of Par Value 200,000



Retained Earnings 500,000



During the year, the following transactions occurred.



Feb. 1 Declared a $1 cash dividend per share to stockholders of record on February 15,



payable March 1.



Mar. 1 Paid the dividend declared in February.



Apr. 1 Announced a 5-for-1 stock split. Prior to the split, the market price per share was $35.



July 1 Declared a 5% stock dividend to stockholders of record on July 15, distributable July



31. On July 1, the market price of the stock was $7 per share.



July 31 Issued the shares for the stock dividend.



Dec. 1 Declared a $0.50 per share dividend to stockholders of record on December 15,



payable January 5, 2009.



31 Determined that net income for the year was $380,000.





Instructions



(a) Journalize the transactions and closing entries.



(b) Enter the beginning balances and post the entries to the stockholders’ equity accounts.



(Note: Open additional stockholders’ equity accounts as needed.)



(c) Prepare a stockholders’ equity section at December 31.







P12-5A The ledger of Nakona Corporation at December 31, 2008, after the books have been



closed, contains the following stockholders’ equity accounts.



Preferred Stock (10,000 shares issued) $1,000,000



Common Stock (400,000 shares issued) 2,000,000



Paid-in Capital in Excess of Par Value—Preferred 200,000



Paid-in Capital in Excess of Stated Value—Common 1,100,000



Common Stock Dividends Distributable 200,000



Retained Earnings 2,365,000



A review of the accounting records reveals the following.



1. No errors have been made in recording 2008 transactions or in preparing the closing entry for



net income.



2. Preferred stock is 8%, $100 par value, noncumulative, and callable at $125. Since January 1,



2007, 10,000 shares have been outstanding; 20,000 shares are authorized.



3. Common stock is no-par with a stated value of $5 per share; 600,000 shares are authorized.



4. The January 1 balance in Retained Earnings was $2,450,000.



5. On October 1, 100,000 shares of common stock were sold for cash at $8 per share.



6. A cash dividend of $600,000 was declared and properly allocated to preferred and common



stock on November 1. No dividends were paid to preferred stockholders in 2007.



7. On December 31, a 10% common stock dividend was declared out of retained earnings on



common stock when the market price per share was $7.



8. Net income for the year was $795,000.



9. On December 31, 2008, the directors authorized disclosure of a $100,000 restriction of retained



earnings for plant expansion. (Use Note A.)





Instructions



(a) Reproduce the Retained Earnings account (T-account) for the year.



(b) Prepare a retained earnings statement for the year



(c) Prepare a stockholders’ equity section at December 31.



(d) Compute the earnings per share of common stock using 325,000 as the weighted average



shares outstanding for the year.



(e) Compute the allocation of the cash dividend to preferred and common stock.


Given the following data:




Average Daily TV Viewing Time Per U.S. Household



Average Daily TV Viewing Time Per U.S. Household





Year Code (t) Total Minutes



Year Code (t) Total Minutes





1950 1 275



1950 1 275





1955 2 291



1955 2 291





1960 3 306



1960 3 306





1965 4 329



1965 4 329





1970 5 356



1970 5 356





1975 6 367



1975 6 367





1980 7 396



1980 7 396





1985 8 430



1985 8 430





1990 9 413



1990 9 413





1995 10 437



1995 10 437





2000 11 455





2005 12 ?



2005 12 ?





(a) Plot the total minutes of TV viewing time per household.



(a) Plot the total minutes of TV viewing time per household.



(b) Describe the trend (if any) and discuss possible causes.



(b) Describe the trend (if any) and discuss possible causes.



(c) Fit a linear trend to the data.



(c) Fit a linear trend to the data.



(d) Would this model give reasonable forecasts? Would another trend model be better? Explain. (e) Make a forecast for 2005. Note: Time is in 5-year increments, so use t = 12 for the 2005 forecast.



(d) Would this model give reasonable forecasts? Would another trend model be better? Explain. (e) Make a forecast for 2005. Note: Time is in 5-year increments, so use t = 12 for the 2005 forecast.











Part 2. Given the following data:





Asian and European share of U.S light truck sales. 1990-2003



Year Percent Year Percent



1990 16.4 1997 15.4



1991 17.1 1998 16.2



1992 14.3 1999 18.4



1993 13.7 2000 21.2



1994 14.2 2001 23.1



1995 13.6 2002 23.9



1996 13.6 2003 25.6





(a) Plot the market-share data. (b) Describe the trend (if any) and discuss possible causes. (c) Fit three trends (linear, exponential, quadratic). (d) Which trend model is best, and why? If none is satisfactory, explain. (e) Make a forecast for 2004 by using a trend model of your choice or a judgment forecast.


4.1 The following gives the number of pints of type A


blood used at Woodlawn Hospital in the past 6 weeks:



Week Of Pints Used



August 31 360



September 7 389



September 14 410



September 21 381



September 28 368



October 5 374



a) Forecast the demand for the week of October 12 using a 3-week moving average.



b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12.



c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and = .2.





4.3 Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the naive forecast. Based on a visual inspection, which forecast is better



Year 1 2 3 4 5 6 7 8 9 10 11



Demand 7 9 5 9 13 8 12 13 9 11 7





4.5 The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows:



Year Mileage



1 3,000



2 4,000



3 3,400



4 3,800



5 3,700



a) Forecast the mileage for next year using a 2-year moving average.



b) Find the MAD based on the 2-year moving average forecast in part (a). (Hint: You will have only 3 years of matched data.)



c) Use a weighted 2-year moving average with weights of .4 and .6 to forecast next year’s mileage. (The weight of .6 is for the most recent year.) What MAD results from using this approach to forecasting? (Hint: You will have only 3 years of matched data.)



d) Compute the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 3,000 miles, and = .5.





4.25 The following gives the number of accidents that



occurred on Florida State Highway 101 during the last 4 months:



Month Number of Accidents



January 30



February 40



March 60



April 90



Forecast the number of accidents that will occur in May, using least squares regression to derive a trend equation.





4.27 Mark Cotteleer owns a company that manufactures sailboats. Actual demand for Mark’s sailboats during each season in 2004 through 2007 was as follows:



Year



Season 2004 2005 2006 2007



Winter 1,400 1,200 1,000 900



Spring 1,500 1,400 1,600 1,500



Summer 1,000 2,100 2,000 1,900



Fall 600 750 650 500



Mark has forecasted that annual demand for his sailboats in 2009 will equal 5,600 sailboats. Based on this data and the multiplicative seasonal model, what will the demand level be for Mark’s sailboats in the spring of 2009?





4.33 The number of transistors (in millions) made at a plant in Japan during the past 5 years follows:



Year Transistors



1 140



2 160



3 190



4 200



5 210



a) Forecast the number of transistors to be made next year, using linear regression.



b) Compute the mean squared error (MSE) when using linear regression.



c) Compute the mean absolute percent error (MAPE).


        The Haverly Company expects to finish the current year with the following financial results, and is developing its Annual Plan for next year.


 



HAVERLY COMPANY



THIS YEAR



INCOME STATEMENT



($000)



                                                                            $                                    %               



                            Revenue                                    $73,820                      100.0



                            COGS                                 31,743                              43.0



                                   Gross Margin                               $42,077                              57.0



 



                            Expenses:



                                  Marketing                                 $17,422                              23.6



                                  Engineering                       7,087                                9.6



                                  Fin & Admin                      7,603                              10.3



                                Total Expense              $32,112                              43.5



 



                            EBIT                                            $  9,965                              13.5



                            Interest                                   $  2,805                  3.8



                            EBT                                             $  7,160                   9.7



                            Income Tax                                 $  3,007                   4.1



                            EAT                                             $  4,153                   5.6



  



HAVERLY COMPANY



THIS YEAR



INCOME STATEMENT



($000)



                                       ASSETS                 LIABILITIES & EQUITY



Cash                                           $  8,940                            Accounts Payable                 $ 1,984



Accounts Rec.                            $12,303                            Accruals                                    $    860



Inventory                                 $  7,054                    Current Liabilities                 $ 2,844



    Current Assets               $28,297



                                                                              Long Term Debt                $22,630



Fixed Assets                                                        Equity



    Gross                                    $65,223                   Stock Accounts                  $18,500



    Accum. Deprec.        ($23,987)                  Retained Earn.              $25,559



    Net                                           $41,236                    Total Equity                              $44,059



 



Total Assets                              $69,533                            Total L&E                                   $69,533



 



     The following facts are available



       1. Payables are almost entirely due to inventory purchases, and can be estimated through COGS, which is approximately 45% purchased material. 



       2. Currently owned assets will depreciate an additional $1,840,000 next year.



       3. There are two balance sheet accruals.  The first is for unpaid wages.  The current payroll of $32 million is expected to grow by 12% next year.  The closing date of the year will be six working days after a payday.  The second accrual is an estimate of the cost of purchased items that have arrived in inventory, but for which vendor invoices have not yet been received.  This materials accrual is generally about 10% of the payables balance at year end.



       4. The combined state and federal income tax rate is 42%.



       5. Interest on current and future borrowing will be at a rate of 12%.



 



PLANNING ASSUMPTIONS



Income Statement Items



       1. Revenue will grow by 13% with no change in product mix.  However, competitive pressure is expected to force some reductions in pricing.



       2. The pressure on prices will result in a 1.5% deterioration in next year's cost ratio.



       3. Spending in the marketing department is considered excessive and will be held to 21% of revenue next year. 



       4. Due to a major development project, expenses in the engineering department will increase by 20%. 



       5. Finance and administration expenses will increase by 6%.



 



Assets and Liabilities



       6. An enhanced cash management system will reduce cash balances by 10%.



       7. The ACP will be reduced by 15 days.  (Calculate the current value to arrive at the target.)



       8. The inventory turnover ratio (COGS/Inv.) will decrease by .5.



       9. Capital spending is expected to be $7 million.  The average depreciation life of the assets to be acquired is five years.  The firm uses straight-line depreciation, and takes a half-year in the first year. 



      10. Bills are currently paid in 50 days.  Plans are to shorten that to 40 days.



      11. A dividend totaling $1.5 million will be paid next year.  No new stock will be sold.



 



     Develop next year's financial plan for Haverly based on these assumptions and last year's financial statements.  Include a projected income statement, balance sheet and a statement of cash flows.