Can someone walk me through on a simple income statement and balance sheet for YEAR 2 from these pics, please?
ENTR 400 - Business Venture Introduction.docx - Microsoft Excel Starter File Home Insert Page Layout Formulas Calibri ' Wrap Text General E AutoSum - EF Past B Merge & Center - % Conditional Format Cell Insert Delete Format 2 Clear Sort & Find & Spelling Purchase Formatting . as Table . Styles - Filter . Select Clipboard Font Alignment Number Styles Cells Editing Proofing Upgrade G1 fix B C D E G H N Get Started 1 Costs Estimates Year 1 Year 2 Year 3 After the last assignment and my poor performance with the lack of information, I figured I 10,200.00 $ 12,000.00 $ 14,400.00 would support my information with the links to the Brunswick Copmany. The Brunswick Co. Getting Started Guide 2 Office Space S Help and Support 3 Supplies S 15,089.76 |$ 17,353.22 |$ 21,344.47 is the market leader in the marine, fitness and billards industries. I figured I would sort of 4 Communications S 1,440.00 $ 1,740.00 $ 1,920.00 mirror their success, but of course on a much smaller scale. + Do More 5 Utilities 2,220.00 |$ 2,580.00 $ 2,880.00 Get Free Templates S 6 Insurance 1,320.00 $ 1,800.00 $ 2,100.00 Brunswicks supply inventory grew by 30%. I figured a more optimistic increase would be Download Clip Art Lawyer and Accountant 5,400.00 $ 5,400.00 $ 5,400.00 around half of that (15%) =+ Get More 8 Inventory 96,000.00 $140,160.00 $164,160.00 With Brunswick Co their inventory increase by 94%. Being optimistic with a new business Get Microsoft PowerPoint or Microsoft 9 Advertising/Marketing $ 3,000.00 $ 3,450.00 $ 3,517.50 venutre, I Increased in by half that (46%). Outlook 10 Website S 100.00 $ 500.00 $ 500.00 11 Employee (3-5) $ $ 99,840.00 $166,400.00 As I stated in the previous assignemnt, I spoke to local marine companies Hamburg Sud and 12 TOTAL 134,769.76 $ 284,823.22 $382,621.97 Jersey Marine. They were kind of protective of a lot of their information even though I told them that it was for a school assignment. I figured they were protective thinking I was trying 14 to poach their customers. http://ir.brunswick.com/financial-information/annual-reports https://csimarket.com/stocks/suppliers_glance.php?code=BC Advertisement Micros 24 25 Activate Go to Sett 98.Office dows. Assignment 3 Assignment 4 Assignment 4 #2 Assignment #6 Assignment #7 Ready 100% - O Type here to search Ei em X W 7:23 PM 11/9/2018ENTR 400 - Assignment 5.1 - Estimating Revenues - Microsoft Excel Starter File Home Insert Page Layout Formulas Calibri ' Wrap Text General E AutoSum - Paste B Merge & Center % Conditional Format Cell Insert Delete Format Sort & Find & Spelling Purchase Formatting . as Table - Styles - 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing Proofing Upgrade A16 fx A B H M N P Get Started 1 Consolidated Optimistic Estimated Revenues 2018 Getting Started Guide 2 Date 2019 2020 Help and Support 3 January $ 6,800.05 |$ 7,208.05 $ 8,000.94 So, to be optimistic, after doing some marketing research for boating equipment companies within 4 February $ 10,073.46 $ 10,677.87 $ 11,852.43 my geographical area, it is known that businesses have seen between 6-10% growth rate. I stuck with + Do More 5 March $ 10,098.51 $ 10,704.42 |$ 11,881.91 6% due to it being a new bsuiness venture. Get Free Templates 6 April $ 10,028.83 $ 10,630.56 $ 11, 799.92 Download Clip Art May $ 7,019.63 $ 7,440.81 $ 8,259.30 _+ Get More 8 June $ 10,121.14 $ 10,728.41 $ 11,908.53 Get Microsoft PowerPoint or Microsoft 9 July $ 7,093.52 $ 7,519.13 $ 8,346.24 Outlook 10 August $ 6,010.65 $ 6,371.29 $ 7,072.13 11 September |$ 7,081.65 |$ 7,506.55 $ 8,332.27 12 October $ 8,032.17 $ 8,514. 10 $ 9,450.65 13 November |$ 4,084.38 $ 4,329.44 $ 4,805.68 14 December |$ 1,061.30 $ 1, 124.98 $ 1,248.73 15 Total $ 87,505.29 $92,755.61 $ 102,958.72 16 17 18 Advertisement Microsoft 18 25 Activate W nde Office Optimistic Est Rev Pessimistic Est Rev Go to Settin nows. Sheet3 Ready 100% - O Type here to search Ei X W 7:22 PM 11/9/2018
