Scribd Logo
Upload

Welcome to Scribd!

  • 3K views

    Sweet Beginnings Co.

    Uploaded by

    Andrew Farol
    The document provides financial information for Sweet Beginnings Co., including monthly income statements for 20X5-20X6 and annual income statements for 2014-2016. It shows that the company's net sales and profits increased each year, with net profit reaching $9.48 million in 2016. The company experienced large fluctuations in its monthly cash flows throughout 20X6.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Sweet Beginnings Co.

    Uploaded by

    Andrew Farol
    3K views11 pages
    The document provides financial information for Sweet Beginnings Co., including monthly income statements for 20X5-20X6 and annual income statements for 2014-2016. It shows that the company's net sales and profits increased each year, with net profit reaching $9.48 million in 2016. The company experienced large fluctuations in its monthly cash flows throughout 20X6.

    Original Description:

    Sweet Beginnings Co.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides financial information for Sweet Beginnings Co., including monthly income statements for 20X5-20X6 and annual income statements for 2014-2016. It shows that the company's net sales and profits increased each year, with net profit reaching $9.48 million in 2016. The company experienced large fluctuations in its monthly cash flows throughout 20X6.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    3K views11 pages

    Sweet Beginnings Co.

    Uploaded by

    Andrew Farol
    The document provides financial information for Sweet Beginnings Co., including monthly income statements for 20X5-20X6 and annual income statements for 2014-2016. It shows that the company's net sales and profits increased each year, with net profit reaching $9.48 million in 2016. The company experienced large fluctuations in its monthly cash flows throughout 20X6.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 11

    Sweet Beginnings Co.

    Monthly Income Statement


    20X6 20X6 20X6 20X6 20X6 20X6
    Jan Feb Mar Apr May Jun
    Cash
    Accounts receivable
    Inventories
    Total current assets

    Gross plant, property and equipment


    Accumulated depreciation
    Net PPE
    Total assets

    Accounts payable
    Short term borrowings
    Accrued taxes
    Total current liabilities

    Owner's equity
    Total liability and equity
    20X6 20X6 20X6 20X6 20X6 20X6
    Jul Aug Sep Oct Nov Dec TOTAL
    Sweet Beginnings Co.
    Monthly Income Statement
    20X5 20X6 20X6 20X6
    Dec Jan Feb Mar
    Cash receipts from collections 2,212,016.00 1,821,337.20 1,956,921.60
    Less: Purchase of raw materials 1,120,779.00 1,664,322.00 3,206,982.08 6,010,050.48
    Less: Payment for salaries and wages 381,064.86 565,869.48 1,090,373.91
    Less: Payment to delivery contractors 49,004.64 73,262.16 108,300.24
    Less: Dividends paid 450,000.00
    Less: Income tax paid
    Net cash flow 117,624.50 - 2,024,776.52 - 5,701,803.02
    Add: Beginning cash 53,426.92 53,426.92 53,426.92
    Less: Required ending balance 53,333.33 53,333.33 53,333.33
    Add: Return on investment (1%)
    Less: Interest on borrowing (16%) 7,834.33 7,834.33 7,834.33
    Less: Repayment of principal 587,575.00
    Add: Liquidation of investment
    Required financing
    Excess cash
    109,883.75 - 2,032,517.27 - 6,297,118.77
    20X6 20X6 20X6 20X6 20X6 20X6
    Apr May Jun Jul Aug Sep
    2,909,246.40 5,386,702.80 10,352,240.60 15,275,301.60 16,728,151.80 12,497,892.50
    8,603,859.55 9,096,584.89 6,448,028.13 3,376,092.50 2,250,727.19 1,855,328.75
    2,043,417.16 2,925,312.25 3,092,838.86 2,192,329.56 1,147,871.45 765,247.24
    241,552.35 414,089.52 524,513.34 467,841.38 235,579.88 132,721.13
    450,000.00 450,000.00
    363,834.79 1,862,284.92
    - 7,979,582.66 - 7,413,118.64 - 163,139.73 9,239,038.16 11,231,688.37 9,294,595.38
    53,426.92 53,426.92 53,426.92 53,426.92 53,426.92 53,426.92
    53,333.33 53,333.33 53,333.33 53,333.33 53,333.33 53,333.33

    7,834.33 7,834.33 7,834.33 7,834.33 7,834.33 7,834.33

    - 7,987,323.41 - 7,420,859.39 - 170,880.48 9,231,297.41 11,223,947.62 9,286,854.63


    20X6 20X6 20X6
    Oct Nov Dec TOTAL
    6,481,212.50 4,158,592.50 3,450,745.00 83,230,360.50
    1,490,345.31 1,208,184.48 1,344,934.80 46,555,440.14
    630,811.78 506,717.41 410,782.72 15,752,636.68
    112,812.75 89,586.75 72,996.38 2,522,260.50
    450,000.00 1,800,000.00
    1,319,432.67 3,545,552.38
    4,247,242.66 1,034,671.20 1,172,031.10 13,054,470.81
    53,426.92 53,426.92 53,426.92 641,123.00
    53,333.33 53,333.33 53,333.33 640,000.00
    -
    7,834.33 7,834.33 7,834.33 94,012.00
    587,575.00
    -
    -
    -
    4,239,501.91 1,026,930.45 1,164,290.35 12,374,006.81
    Sweet Beginnings Co.
    Monthly Income Statement
    20X4 20X5 20X6 20X6 20X6
    Jan Feb Mar
    Gross sales 55,546,936.00 66,306,050.00 1,633,488.00 2,442,072.00 3,610,008.00
    Cost of goods sold 38,327,385.00 46,398,029.00 1,203,880.66 1,799,807.06 2,660,575.90
    Gross profit 17,219,551.00 19,908,021.00 429,607.34 642,264.94 949,432.10
    Delivery fees 1,666,408.00 1,989,182.00 49,004.64 73,262.16 108,300.24
    Operating expenses 3,012,444.00 4,159,275.00 98,009.28 146,524.32 216,600.48
    Depreciation 869,600.00 869,600.00 82,466.67 82,466.67 82,466.67
    Interest expense 910,000.00 1,240,000.00 7,834.33 7,834.33 7,834.33
    Pretax profit 10,761,099.00 11,649,964.00 192,292.42 332,177.46 534,230.38
    Income tax 3,099,519.00 3,583,444.00 77,329.32 115,607.69 170,897.78
    Net profit 7,661,580.00 8,066,520.00 114,963.10 216,569.77 363,332.61
    20X6 20X6 20X6 20X6 20X6 20X6
    Apr May Jun Jul Aug Sep
    8,051,745.00 13,802,984.00 17,483,778.00 15,594,712.50 7,852,662.50 4,424,037.50
    5,934,136.07 10,172,799.21 12,885,544.39 11,493,303.11 5,787,412.26 3,260,515.64
    2,117,608.94 3,630,184.79 4,598,233.61 4,101,409.39 2,065,250.24 1,163,521.86
    241,552.35 414,089.52 524,513.34 467,841.38 235,579.88 132,721.13
    483,104.70 828,179.04 1,049,026.68 935,682.75 471,159.75 265,442.25
    82,466.67 82,466.67 82,466.67 82,466.67 82,466.67 82,466.67
    7,834.33 7,834.33 7,834.33 7,834.33 7,834.33 7,834.33
    1,302,650.89 2,297,615.23 2,934,392.59 2,607,584.26 1,268,209.61 675,057.49
    381,169.61 653,433.26 827,682.05 738,253.69 371,745.04 209,433.94
    921,481.28 1,644,181.97 2,106,710.54 1,869,330.57 896,464.57 465,623.55
    20X6 20X6 20X6 20X6
    Oct Nov Dec TOTAL
    3,760,425.00 2,986,225.00 2,433,212.50 84,075,350.00
    2,771,433.23 2,200,847.83 1,793,277.61 61,963,532.95 0.73700
    988,991.78 785,377.18 639,934.89 22,111,817.05 22,111,817.05
    112,812.75 89,586.75 72,996.38 2,522,260.50 0.03
    225,625.50 179,173.50 145,992.75 5,044,521.00 0.06
    82,466.67 82,466.67 82,466.67 989,600.00
    7,834.33 7,834.33 7,834.33 94,012.00 94,012.00
    560,252.53 426,315.93 330,644.76 13,461,423.55
    178,018.52 141,367.89 115,188.28 3,980,127.07
    382,234.01 284,948.03 215,456.48 9,481,296.48
    2015 2016 2017 1,120,779.00
    Jan 1,361,240.00 1,633,488.00 1,960,185.60 1,664,322.00
    Feb 2,035,060.00 2,442,072.00 2,930,486.40 3,206,982.08
    Mar 3,008,340.00 3,610,008.00 6,010,050.48
    Apr 6,193,650.00 8,051,745.00 8,603,859.55
    May 10,617,680.00 13,802,984.00 9,096,584.89
    Jun 13,449,060.00 17,483,778.00 6,448,028.13
    July 12,475,770.00 15,594,712.50 3,376,092.50
    Aug 6,282,130.00 7,852,662.50 2,250,727.19
    Sept 3,539,230.00 4,424,037.50 1,855,328.75
    Oct 3,008,340.00 3,760,425.00 1,490,345.31
    Nov 2,388,980.00 2,986,225.00 1,208,184.48
    Dec 1,946,570.00 2,433,212.50 1,344,934.80
    66,306,050.00 84,075,350.00
    Sweet Beginnings Co.
    Income Statement
    For the year ended Dec. 2016

    2014 2015 2016


    Gross sales 55,546,936.00 66,306,050.00 84,075,350.00
    Cost of goods sold 38,327,385.00 46,398,029.00 61,963,532.95
    Gross profit 17,219,551.00 19,908,021.00 22,111,817.05
    Delivery fees 1,666,408.00 1,989,182.00 2,522,260.50
    Operating expenses 3,012,444.00 4,159,275.00 5,044,521.00
    Depreciation 869,600.00 869,600.00 989,600.00
    Interest expense 910,000.00 1,240,000.00 94,012.00 103,333.33
    Pretax profit 10,761,099.00 11,649,964.00 13,461,423.55 8.806451613
    Income tax 3,099,519.00 3,583,444.00 3,980,127.07
    Net profit 7,661,580.00 8,066,520.00 9,481,296.48

    Sweet Beginnings Co.


    Balance Sheet
    As of December 31, 2015

    2015
    Cash 641,123.00
    Accounts receivable 3,379,958.00
    Inventories 1,076,000.00
    Total current assets 5,097,081.00

    Gross plant, property and equipment 8,696,000.00


    Accumulated depreciation 1,278,500.00
    Net PPE 7,417,500.00
    Total assets 12,514,581.00

    Accounts payable 654,234.00


    Short term borrowings 587,575.00
    Accrued taxes 1,321,900.00
    Total current liabilities 2,563,709.00

    Owner's equity 9,950,872.00


    Total liability and equity 12,514,581.00
    7,750,000.00

    1,937,500.00

    0.075816129

    You might also like