Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISE Real Estate Finance And Investments

Authors: Jeffrey Fisher William B. Brueggeman

17th International Edition

1264892888, 9781264892884

More Books

Students also viewed these Finance questions

Question

9. How are they similar to you? (specifically)

Answered: 1 week ago

Question

13. What are their tastes? (refined, middle class, or subsistence)

Answered: 1 week ago