Question
EXHIBIT 6 Omega Protein Corp., Pro Forma Cash Flow Year 1 Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. Totals Cash
EXHIBIT 6 Omega Protein Corp., Pro Forma Cash Flow | ||||||||||||||||
Year 1 | ||||||||||||||||
Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sept. | Oct. | Nov. | Dec. | Totals | ||||
Cash Receipts | ||||||||||||||||
Sales (1) | 32,566,667 | 32,593,806 | 32,620,967 | 32,648,151 | 32,675,358 | 32,702,587 | 32,729,840 | 32,757,114 | 32,784,412 | 32,811,732 | 32,839,076 | 32,866,441 | 392,596,151 | |||
Cash from owner (owner Injection) | - | - | - | - | - | - | - | - | - | - | - | - | - | |||
Total cash receipts | 32,566,667 | 32,593,806 | 32,620,967 | 32,648,151 | 32,675,358 | 32,702,587 | 32,729,840 | 32,757,114 | 32,784,412 | 32,811,732 | 32,839,076 | 32,866,441 | 392,596,151 | |||
Cash Disbursements | ||||||||||||||||
Cost of goods sold (2) | 6,207,207 | 6,212,379 | 6,217,556 | 6,222,738 | 6,227,923 | 6,233,113 | 6,238,307 | 6,243,506 | 6,248,709 | It is ok just do whatever is there Estimated Sales Omega Protein Corp. 1000000 Years Ended December 31, 2016 2015 2014 Revenues Percent Revenues Percent Revenues Percent % Change from 2015-2016 % Change from 2015-2016 Animal Nutrition Revenues Fish meal 169,700,000.00 55% 152,400,000.00 42% 147,100,000.00 48% 13% -5% Fish Oil 65,500,000.00 21% 39,300,000.00 11% 70,800,000.00 23% 10% -12% Refined Fish Oil 25,100,000.00 8% 23,800,000.00 7% 22,200,000.00 7% 2% -1% Fish Solubles and Other 2,200,000.00 1% 4,600,000.00 1% 3,700,000.00 1% -1% 0% Subtotal of Animal Nutrition 262,500,000.00 67% 220,100,000.00 61% 243,800,000.00 79% 6% -18% Human Nutrition Revenues Speciality Oils 101,000,000.00 26% 113,700,000.00 32% 41,100,000.00 13% -6% 18% Dairy Protein Products 16,900,000.00 4% 12,900,000.00 4% 11,700,000.00 4% 1% 0% Other Nutraceutical Products 10,400,000.00 3% 12,600,000.00 4% 12,000,000.00 4% -1% 0% Subtotal of Human Nutrition 128,300,000.00 33% 139,200,000.00 39% 64,800,000.00 21% -6% 18% Total 390,800,000.00 100% 359,300,000.00 100% 308,600,000.00 100% 0% 0% % sales per month Based on Simple Linear Regression Trend Forecast model with 1% annual growth Monthly growth = 1.00%/12 = .08333 EXHIBIT 9 - Sales Forecast Based on a Simple Linear Regression Trend Forecast model Slope Intercept 27252.22 32539206.51 Year 1 Period Actual Demand: At Trend Forecast Ft Sales Estimated Income from Sales 1 32,566,666.67 32566458.73 $32,566,458.73 $32,566,458.73 2 32,593,805.56 32593710.96 $32,593,710.96 $32,593,710.96 3 32,620,967.06 32620963.18 $32,620,963.18 $32,620,963.18 4 32,648,151.20 32648215.40 $32,648,215.40 $32,648,215.40 5 32,675,357.99 32675467.62 $32,675,467.62 $32,675,467.62 6 32,702,587.46 32702719.84 $32,702,719.84 $32,702,719.84 7 32,729,839.61 32729972.07 $32,729,972.07 $32,729,972.07 8 32,757,114.48 32757224.29 $32,757,224.29 $32,757,224.29 9 32,784,412.08 32784476.51 $32,784,476.51 $32,784,476.51 10 32,811,732.42 32811728.73 $32,811,728.73 $32,811,728.73 11 32,839,075.53 32838980.96 $32,838,980.96 $32,838,980.96 12 32,866,441.43 32866233.18 $32,866,233.18 $32,866,233.18 32,893,830.13 $392,596,151.47 $392,596,151.47 Slope Intercept 285678.45 29158449.61 Year 2 Period Actual Demand: At Trend Forecast Ft Sales Estimated Income from Sales 13 32893830.13 32872269.52 $32,872,269.52 $32,872,269.52 14 33167835.73 33157947.97 $33,157,947.97 $33,157,947.97 15 33444123.80 33443626.43 $33,443,626.43 $33,443,626.43 16 33722713.35 33729304.88 $33,729,304.88 $33,729,304.88 17 34003623.56 34014983.33 $34,014,983.33 $34,014,983.33 18 34286873.74 34300661.79 $34,300,661.79 $34,300,661.79 19 34572483.40 34586340.24 $34,586,340.24 $34,586,340.24 20 34860472.19 34872018.70 $34,872,018.70 $34,872,018.70 21 35150859.92 35157697.15 $35,157,697.15 $35,157,697.15 22 35443666.58 35443375.60 $35,443,375.60 $35,443,375.60 23 35738912.32 35729054.06 $35,729,054.06 $35,729,054.06 24 36036617.46 36014732.51 $36,014,732.51 $36,014,732.51 36336802.49 $413,322,012.19 $413,322,012.19 Slope Intercept 312973.14 28188668.48 Year 3 Period Actual Demand: At Trend Forecast Ft Sales Estimated Income from Sales 25 36036617.46 36012996.88 $36,012,996.88 $36,012,996.88 26 36336802.49 36325970.02 $36,325,970.02 $36,325,970.02 27 36639488.05 36638943.15 $36,638,943.15 $36,638,943.15 28 36944694.99 36951916.29 $36,951,916.29 $36,951,916.29 29 37252444.30 37264889.43 $37,264,889.43 $37,264,889.43 30 37562757.16 37577862.56 $37,577,862.56 $37,577,862.56 31 37875654.93 37890835.70 $37,890,835.70 $37,890,835.70 32 38191159.13 38203808.83 $38,203,808.83 $38,203,808.83 33 38509291.49 38516781.97 $38,516,781.97 $38,516,781.97 34 38830073.88 38829755.11 $38,829,755.11 $38,829,755.11 35 39153528.40 39142728.24 $39,142,728.24 $39,142,728.24 36 39479677.29 39455701.38 $39,455,701.38 $39,455,701.38 $452,812,189.57 $452,812,189.57 6,253,916 | 6,259,128 | 6,264,344 | 74,828,826 | |||
Salaries (3) | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 242,944 | 2,915,328 | |||
Commercial Mortgage (4) | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||
Interest (6) | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||
Depreciation (9) | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 96,648 | 1,159,775 | |||
Insurance (10) | - | - | - | - | - | - | - | - | - | - | - | - | - | |||
Repairs and maintenance (11) | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 5,917 | 71,000 | |||
Office Expenses | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2,400 | |||
Total cash disbursements | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||
Net Cash Flow | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |||
Notes: | ||||||||||||||||
(1) The cash portion of sales is counted when received. If credit is used, only the cash portion of the sale can be counted. The remaining cash is counted as the customer pays. In this firm all sales are cash or credit card which is the same as cash. Therefore, the cash receipts from sales are the same as on the income statement. | ||||||||||||||||
(2) Cost of goods sold is 19.06% of sales estimated using Bizstats.com. An Amusement, gambling and recreation industries class corporation and annual sales of $2,077,049.96 were used to customize the financial statements. http://www.bizstats.com/corporation-industry-financials/arts-entertainment-recreation-71/amusement-gambling-and-recreation-industries-713/show | ||||||||||||||||
(3) From Uses of funds exhibit for the hire of twenty-three employees. See salaries tab for detail. | ||||||||||||||||
(4) Average principal paid on Commercial Mortgage loan. See Amortization schedule. | ||||||||||||||||
(6) Average interest paid on Commercial Mortgage and SBA 7(a) loan. See Amortization schedule. | ||||||||||||||||
(9) Depreciation - all equipment will be depreciated per modified accelerated cost recovery system (MACRS). See depreciation schedules. | ||||||||||||||||
(10) Insurance was prepaid for the first year and included in the Start-up Expenses | ||||||||||||||||
(11) Repairs and maintenance are included in turnkey contracts as apart of first year satisfaction guarantee. | ||||||||||||||||
EXHIBIT 12 - Taxable Salaries & Wages | ||||||||||||||||
Tax Rates | Tax Amounts | Earned Wages | ||||||||||||||
Medicare | Social Security | Medicare | Social Security | |||||||||||||
Truck Drivers - $27/hr - 20/day @ 30 day/mo | 129,600.00 | 1.45% | 6.20% | 1,879.20 | 8,035.20 | 119,685.60 | ||||||||||
Logisitics/Scheduling Coordinator $14/8hr shift - 7/day @ 30 day/mo | 23,520.00 | 1.45% | 6.20% | 341.04 | 1,458.24 | 21,720.72 | ||||||||||
Dispatcher $12/8hr shift - 7/day @ 30 day/mo | 20,160.00 | 1.45% | 6.20% | 292.32 | 1,249.92 | 18,617.76 | ||||||||||
Data Management Supervisor $18/8hr shift - 7/day @ 30 day/mo | 30,240.00 | 1.45% | 6.20% | 438.48 | 1,874.88 | 27,926.64 | ||||||||||
Manager $32/8hr shift - 7/day @ 22day/mo | 39,424.00 | 1.45% | 6.20% | 571.65 | 2,444.29 | 36,408.06 | ||||||||||
Total | 242,944 | 3,523 | 15,063 | 224,359 | ||||||||||||
242,944.00 | Monthly Wages | 18,585.22 | Monthly pd Tax | |||||||||||||
2,915,328.00 | Annual Wages | 223,022.59 | Annual pd Tax | |||||||||||||
728,832.00 | Qtrly Wages | 55,755.65 | Qtrly pd Tax | |||||||||||||
EXHIBIT 8 Omega Protein Corp., Pro Forma Balance Sheet | ||||||||||||||||
End of: | Year 0 | Year 1 | Year 2 | Year 3 | Year 0 | Year 1 | Year 2 | Year 3 | ||||||||
Assets | Liabilities | |||||||||||||||
Current Assets | Current Liabilities | |||||||||||||||
Cash (1) | #REF! | #REF! | #REF! | Accounts payable (6) | #REF! | #REF! | #REF! | #REF! | ||||||||
Inventory (2) | - | #REF! | #REF! | Short term notes payable | - | - | - | - | ||||||||
Prepaid expenses (3) | 108,500 | - | #REF! | #REF! | Total current liabilities | #REF! | #REF! | #REF! | #REF! | |||||||
Office supplies (4) | - | 2,400 | #REF! | #REF! | Long-term Liabilities (7) | |||||||||||
Accounts receivable | - | Commercial Mortgage payable | #REF! | 218,798 | 218,798 | 218,798 | ||||||||||
Total current Assets | 108,500 | #REF! | #REF! | #REF! | SBA 7(a) payable | #REF! | #REF! | #REF! | #REF! | |||||||
Other long-term loans | - | - | - | - | ||||||||||||
Fixed Assets (5) | Total long-term liabilities | #REF! | #REF! | #REF! | #REF! | |||||||||||
Other equipment for amusement center | 1,715,950 | #REF! | #REF! | #REF! | Total Liabilities | #REF! | #REF! | #REF! | #REF! | |||||||
Furniture | #REF! | #REF! | #REF! | #REF! | ||||||||||||
Kitchen equipment | #REF! | 1,372,760 | 823,656 | 494,194 | Owner's equity | |||||||||||
Attraction Equipment | #REF! | 1,633,415 | 544,390 | 181,545 | Paid-In capital from Owners | #REF! | - | - | - | |||||||
Pflugerville Property Remodel | #REF! | #REF! | #REF! | #REF! | Retained earnings | |||||||||||
Total fixed assets | #REF! | #REF! | #REF! | #REF! | Total owner's equity | #REF! | - | - | - | |||||||
Total assets | #REF! | #REF! | #REF! | #REF! | Total Liabilities and Owner's Equity | #REF! | #REF! | #REF! | #REF! | |||||||
Notes: | ||||||||||||||||
(1) Working capital prorated as to cover negative cash flow for 3 1/2 years of operation. | ||||||||||||||||
(2) Assumption of inventory based on 20% of COGS. | ||||||||||||||||
(3) Insurance from startup statements | ||||||||||||||||
(4) From startup statements | ||||||||||||||||
(5) From capital equipment list | ||||||||||||||||
(6) Payables including salaries, utilites, office expenses | ||||||||||||||||
(7) Principal and Interest | ||||||||||||||||
Omega Protein Corporation | ||||||||||||||||
EXHIBIT 1 Sources and Uses | ||||||||||||||||
Sources of funds | ||||||||||||||||
Reinvestment into the company | ||||||||||||||||
Omega Shipyard, Inc (shared 50/50) | 2,757,672 | |||||||||||||||
Omega Protein, Inc (shared 50/50) | 2,757,672 | |||||||||||||||
Total | 5,515,344 | |||||||||||||||
Financing | ||||||||||||||||
Commercial Fleet Retail Loan | 1,200,000 | |||||||||||||||
Total | 1,200,000 | |||||||||||||||
Total Sources | 6,715,344 | |||||||||||||||
Uses of funds | ||||||||||||||||
Identification of Personnel Needed | ||||||||||||||||
Salaries | ||||||||||||||||
Truck Drivers - $27/hr - 20/day @ 30 day/mo | 129,600 | |||||||||||||||
Logisitics/Scheduling Coordinator $14/8hr shift - 7/day @ 30 day/mo | 23,520 | |||||||||||||||
Dispatcher $12/8hr shift - 7/day @ 30 day/mo | 20,160 | |||||||||||||||
Data Management Supervisor $18/8hr shift - 7/day @ 30 day/mo | 30,240 | |||||||||||||||
Manager $32/8hr shift - 7/day @ 22day/mo | 39,424 | |||||||||||||||
Total | 242,944 | |||||||||||||||
Technical Requirements | ||||||||||||||||
Wi-Fi equipment | 2,000 | |||||||||||||||
Mobile iPads for ERP entry | 3,500 | |||||||||||||||
Computers | 75,000 | |||||||||||||||
Server/Cloud Backup | 325,000 | |||||||||||||||
ERP Software | 1,300,000 | |||||||||||||||
Telephones | 450 | |||||||||||||||
CB Radios | 10,000 | |||||||||||||||
Total | 1,715,950 | |||||||||||||||
Materials and Equipment Needed | ||||||||||||||||
Repairs and Maintenance (1) | 71,000 | |||||||||||||||
Oil Changes $180/truck @20/mo | 43,200 | |||||||||||||||
Gasoline (2) | 1,690,000 | |||||||||||||||
Tires $450/tire @18 tires/truck; as needed semi-annually | 324,000 | |||||||||||||||
Accident and Collision Expenses (3) | 50,000 | |||||||||||||||
Total | 2,178,200 | |||||||||||||||
Start-up expenses | 2,578,250 | |||||||||||||||
Working capital (cash) (4) | ||||||||||||||||
Total uses | 6,715,344 | |||||||||||||||
(1) It is estimated that 7.1% of purchase cost to cover repairs and maintenance of fleet | ||||||||||||||||
(2) It is estimated that diesel is $3.38 per gallon and each truck has a capacity of 250 gallons. Based on industry average, trucks can travel 1500 before the next fill up, therefore 100 fill ups/yr/truck. | ||||||||||||||||
(3) It is estimated that 5% of purchase cost to cover accident and collision expenses | ||||||||||||||||
(4) To cover negative cash flow over 2 year of operation as well as contingency fund. See pro forma cash flow statements. | ||||||||||||||||
EXHIBIT 2 Start-Up Expenses | ||||||||||||||||
Operation/distribution consulting (1) | 5,000 | |||||||||||||||
Miscellaneous consulting (legal, permitting, etc.) | ||||||||||||||||
Licenses/Permits $500/truck | 10,000 | |||||||||||||||
Accounting | 1,000 | |||||||||||||||
Legal | 1,500 | |||||||||||||||
Other | 750 | |||||||||||||||
Total | 13,250 | |||||||||||||||
Annual Insurance Cost (2) | ||||||||||||||||
Commercial Property and Casualty Insurance 5,000,000 | 35,000 | |||||||||||||||
General Liability 5,000,000 | 35,000 | |||||||||||||||
Lost Income Coverage 3,000,000 | 21,000 | |||||||||||||||
Product Liability 500,000 | 3,500 | |||||||||||||||
Umbrella Rider for 1,000,000 | 7,000 | |||||||||||||||
Disability Insurance 1,000,000 | 7,000 | |||||||||||||||
Total | 108,500 | |||||||||||||||
Fleet Purchases | ||||||||||||||||
Trucks $50,000/truck @20 trucks | 1,000,000 | |||||||||||||||
Refrigerated trailers $72,500 @ 20 trailers | 1,450,000 | |||||||||||||||
Total | 2,450,000 | |||||||||||||||
Pre-start-up utilities and miscellaneous supplies | ||||||||||||||||
Office supplies | 500 | |||||||||||||||
Other permitting fees | 1,000 | |||||||||||||||
Total | 1,500 | |||||||||||||||
2,578,250 | ||||||||||||||||
(1) Distribution Management Consultant @ 1 month for training on ERP Software and logistics | ||||||||||||||||
(2) $1mm bond rider cost at $7000/bond | ||||||||||||||||
EXHIBIT 3 Capital Equipment List | ||||||||||||||||
Technical Requirements | ||||||||||||||||
Wi-Fi equipment | 2,000 | |||||||||||||||
Mobile iPads for ERP entry | 3,500 | |||||||||||||||
Computers | 75,000 | |||||||||||||||
Server/Cloud Backup | 325,000 | |||||||||||||||
ERP Software | 1,300,000 | |||||||||||||||
Telephones | 450 | |||||||||||||||
CB Radios | 10,000 | |||||||||||||||
Total | 1,715,950 | |||||||||||||||
Fleet Purchases | ||||||||||||||||
Trucks $50,000/truck @20 trucks | 1,000,000 | |||||||||||||||
Refrigerated trailers $72,500 @ 20 trailers | 1,450,000 | |||||||||||||||
Total | 2,450,000 | |||||||||||||||
4,165,950 | ||||||||||||||||
I need the (costs reports) for omega protein, the costs reports is for preparing the begeting< Only the costs Reports> | ||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started