Kaplan ACC499 unit 4 assignment (part 1 and 2)
Unit four Apply Exercise: Monetary Report Evaluation – Rainbow Paint Co. .jpg"> Observe:This is a observe exercise to be carried out earlier than finishing the Project for this unit. Additionally,that is the info for use as the idea on your Unit 9 Ultimate Mission. The options for the Unit four Apply exercise are situated right here. Rainbow Paint Co.'s comparative monetary statements for the years ending December 31, 2013 and 2012 are as follows. The market value of Rainbow Paint Co.'s frequent inventory was $30 on December 31, 1999 and $25 on December 31, 2013. Rainbow Paint Co. Comparative Revenue Assertion For the Years Ended December 31, 2013 and 2012 2013 2012 Gross sales $ 5,125,000 $ three,257,600 Gross sales returns and allowances 125,000 57,600 Internet gross sales $ 5,000,000 $ three,200,000 Price of products offered three,400,000 2,080,000 Gross revenue $ 1,600,000 $ 1,120,000 Promoting bills 650,000 464,000 Administrative bills 325,000 224,000 Whole working bills $ 975,000 $ 688,000 Revenue from operations $ 625,000 $ 432,000 Different earnings 25,000 19,200 Revenue earlier than Curiosity & Taxes $ $ 451,200 650,000 Different expense (curiosity) 105,000 64,000 Revenue earlier than earnings tax $ 545,000 $ 387,200 Revenue tax expense 300,000 176,000 Internet earnings $ 245,000 $ 211,200 ======== ======== Rainbow Paint Co. Comparative Retained Earnings Assertion For the Years Ended December 31, 2013 and 2012 2013 2012 Retained earnings, January 1 $ 723,000 $ 581,800 Add web earnings for 12 months 245,000 211,200 Whole $ 968,000 $ 793,000 Deduct dividends: On most popular inventory $ 40,000 $ 40,000 On frequent inventory 45,000 30,000 Whole $ 85,000 $ 70,000 Retained earnings, December 31 $ 883,000 $ 723,000 ======== ======== .gif">Unit four.jpg"> [AC499: Bachelor’s Capstone in Accounting] .gif">.gif">.gif"> Rainbow Paint C0, Comparative Stability Sheet December 31, 2013 and 2012 Property 2013 2012 Present belongings: Money $ 175,000 $ 125,000 Marketable securities 150,000 50,000 Accounts receivable (web) 425,000 325,000 Inventories 720,000 480,000 Pay as you go bills 30,000 20,000 Whole present belongings $ 1,500,000 $ 1,000,000 Lengthy-term investments 250,000 225,000 Property, plant, and gear (web) 2,093,000 1,948,000 Whole belongings $ three,843,000 $ three,173,000 ======== ======== Liabilities Present liabilities $ 750,000 $ 650,000 Lengthy-term liabilities: Mortgage notice payable, 10%, due 2016 $ 410,000 - Bonds payable, eight%, due 2017 800,000 $ 800,000 Whole long-term liabilities $ 1,210,000 $ 800,000 Whole liabilities $ 1,960,000 $ 1,450,000 Stockholders' Fairness Most popular eight% inventory, $100 par $ 500,000 $ 500,000 Frequent inventory, $10 par 500,000 500,000 Retained earnings 883,000 723,000 Whole stockholders' fairness $ 1,883,000 $ 1,723,000 Whole liabilities and stockholders' fairness $ three,843,000 $ three,173,000 ======== ========= Directions: Decide the next measures for 2013: 1. Working capital 2. Present ratio three. Fast ratio four. Accounts receivable turnover 5. Variety of days' gross sales in receivables 6. Stock turnover 7. Variety of days' gross sales in stock eight. Ratio of fastened belongings to long-term liabilities .gif">Unit four.jpg"> [AC499: Bachelor’s Capstone in Accounting] .gif">.gif">.gif"> 9. Ratio of liabilities to stockholders' fairness 10. Variety of occasions curiosity prices earned 11. Variety of occasions most popular dividends earned 12. Ratio of web gross sales to belongings 13. Fee earned on complete belongings 14. Fee earned on stockholders' fairness 15. Fee earned on frequent stockholders' fairness 16. Earnings per share on frequent inventory 17. Worth-earnings ratio 18. Dividends per share of frequent inventory 19. Dividend yield Unit four Project: Administration Instruments Software .jpg"> Step 1: Apply Full the AC499 Monetary Report Evaluation – Rainbow Paint Co. as observe for the Unit four Project. The options for the evaluation drawback may be discovered right here. Step 2: Evaluation Ratio Sheet Evaluation the AC499 Monetary Report Evaluation Unit four Ratio Sheet. Step three: Monetary Evaluation Full a monetary evaluation of the corporate financials for Quixote Consulting. Use the Excel Template titled: "Unit four Monetary Report Evaluation Template.” Make sure to evaluation the Excel tab titled “Hints & Instructions” earlier than you try the Project tab. Observe: This Quixote Firm file can be your graded Unit four Project,notthe Rainbow CompanyPractice Project. When you're prepared, chances are you'll submit your Quixote Ratio Evaluation Excel template to the Unit four Dropbox web page. Observe:Embrace your identify within the filename of the Project. Very Necessary Observe:The Apply Set isbased on knowledge for “Rainbow Paint Firm.” Do NOTsubmit the Rainbow options within the Unit four Project Dropbox. The Unit four Project is based mostly on the Quixote knowledge collected in Models 2 and three. Nonetheless, The Rainbow Paint Firm knowledge can be a VITAL and integral element of your Unit 9 Ultimate Mission. So, please full the Apply Train AND maintain your work saved in a file for later use.