120 Jx 018 0.1 San Diego Pieure Cra Income Stat Jan1-Dec 31, 201 2030 3023 Sales Cest of Gos Sa Sing Gear & A 66,500,000 11,250,000 4.500.000 14,500,000 Assets E 425,000,000 Current As $ 164,500,000 Cash & 11.112.00 $ 34.31638 Accounts Recal 17,305,000 14,9000 35.500 15318006 500,000 44554800 750,000 60275350 San Diego Pleasure C 11, 2030 and Dec 31, 201 Liabilities Accable 633001 445.000 10877006 Total Expenses 15,592,500 Property Plant & fa 367,950.000 425000 Stockholders' Equity 30 322395.000 Common Stack 12.000.000 OvdDON Ne inviame To Retain anings 1,000 bes $2.791,750 32499000 SALST 43 1725,000 Total Assets Total Liabilities & Stockholders Equity 3,152,000 Autolave Home Insert Draw Calibri Page Layout Formulas A A Data Review View Tell me Pasta 020 20 sets 14 To Cent 15 A 16 -018-01 ' G 18 Nate Depreciation 20 21 Feed As 23 25otal Assets San Diego Pleasure Cra Faded Dec. 31, 2020 and 201 2020 2021 MOutumure US ProjectPart3 Custom Mange & Center $%9 Conditional Form Formatting Table Styles Cel Delete Formal 2000 131,021 Liabilities Current 3 1112005 34226350 39.529.00 17,305,000 1695.000 4324.000 $544,000 Al 33,557,000 500,000 44,554,800 1838.000 Total Current Lib 44,453,000 46.231.000 750.000 A pay 60.279,950 116.474.800 146477.000 1111.000 Telfo 7,550,000 425,000 Stockholders' Equity 5.3530000 28255.000 103455,004) 322.395,000 Com 2000 11000000 1,700,000 1,000,000 6,580,00 Adal Padin Capital 30.400.000 2531000 134367,316 1300000 Totaling BLA 171275.400 21344350 388.778.950 Total Liabilities & Stockholders Equity Preds of leng 28350 D Last T Rep of www a Comments Financial Statements Part 175 Avalyols Part 1 o Alalysis Part 1 Cash Flow Analysis Part2-Gre Part 3-Financing Pat 3-Capital Satin 100% Ready Home Insert Draw Page Layout Formulas Data Review View Tell me Past A : Calibri "AA B OP I D 832 MOutumuro US ProjectPart3 Merge & Center General $-%9 Conditional Form Formaning as Table Styles 8-2-8- Dell Format Share Comments Sat&& Analy I have assessed the information received regarding the 2021 year for San Diego Pleasure Craft and in the income statement they have shown there higher production than the industry comparison. The gross profit for this A MIN Part 1 FS Analysis Part 1 Radio Analys Part 1 Cash Flow Analys Part 2 Growth Par 3-Fing Put 3- Ready & Pre-tax Profit margin =(Net Income + Taxes)/Sales Part 1-Ratio Analysis (Due at the end of Unit 2) Instructions: Research the Boat Building Industry information, then complete the ratio analysis below. Discuss your observations on the results. Please refer to the Project Requirements for complete instructions. Purple ces require a f Yellow cells only repue Complete the Ratio Analysis below. Industry SOPC Median re Comments about specific ratio Current ratio Current sets/C 1.30 1.78 Cameo for industry sees to be better thin SPOC Comments about Categ City Ratio Liguntry gher than the SPDO dectly effects this r Quick ratin (Current assets-venton/C ventory turnover COGS/ Days Receivables 365+Sales/Accounts receivable) Debt-equity rate Totals/ty 0.91 23.20 1.05 Quick re shown that the industry ratio is better than SPOC quick 8.24 try tower for SPDC shows to be much better than the industry 10.52 40 a much quicker for POC this the duty, which Debt to equity 0.32 1.1 det v 17.50 8.53 12.6% 2.60% POC how great fran that the industry having higher pre-tax pratt mag This shows high efficiency to have SPDC beautypally you would want a lower rats when it commovere Ratio The shown good financial and in this there competition in the Profitability to the p t Pre-tax Return on Assets Net Income Taxes/Total assets 19.1% 34.8% Retum on Equity(Net came Tal 4.90% SPOC ng shigh perce 10.20% POC having a higher percentage show they styrt ughty SPOC Financial Statements Part 1 F Analys Part 1 Ratio Analysis Part 1 Cash Flow Analys Part 2-Growth Part 2-Fencing Part 3-Capital Structure Ready MOutumuro US ProjectPart3 Formulas Data Review View Tell me 11 AA Wrap Text General Av E 00 Merge & Center $ % 9 Conditional Format Formatting as Table Style Call Insert Delete Format Home Insert Draw Page Layout Calibri B Paste BIUY c Complete the Following Financial Cash Flow Analysis 1 Compute the operating cash flow (OCF) OCF-EBIT Depreciation Current tax 12 587,607,500 13 14 2 Compute Net Capital Spending Ending set fixed an 328,490,000 -Beginning set fixed $287,398.000 $19.250.000 Net capital spending $60,151,000 34 3 Compute the Change in Net Working Capital Ending NWC Being NWC Change in NWC 4 Compete the Cash Flow from Anels Operating a flow Net capital spending Change in NWC Cash flow from 5 Compute the Cash Flow to Creditors Being long-term debt Tol Cempate Cash Flow to Stackholders Beginning total equity -Ending total equity Dividends Add Toul $14,048,350 $101.400 $13,946,710 SK2,407 500 560,151,000 1394675 8.300050 316434,000 1280,000 4,500,000 37916.000 $171,275,400 $213,667350 17/127.0 194,367,350 $169,103,160 Answer the following questions Which cash flows statement, the Accounting Statement of Cash Flows, or the Cash Flow Analys, more believe that the cash flow analys has the most descriptive and detailed information describing the cash flows the company and is broken down into six segments b. How would you describe SDPC's cash flows? SPOC cash flows have cash on great because the companies turnover time is faster than the industry showing they bility to operate with it. This shows that this company plenty money on hand to grow the company f your previous comment on SDPC's expan The expansion plans for this company are poible because of the o must continue to increase sales which avery likely would a the plant operatio on hand for operating expers and they prove the expansion of this companywi Francial Statements Part 1 FS Aneyse Part 1 Ratio Analysis Part 1 Cash Flow Analysis Part 2 Growth Part 3-Tuning P3-Capitalructure Ready 203 3 Paste 383 T BIU x fx =SUM(068-067)/[D62) Merge & Center $%9 T " 3 + Output are DO NOT TYPE in this box! Financial Statements Ready ME A T 3 Cell Delete Forma Conditional Format Formatting as Table Styles Part 1 FS Analys Part 1 Ratio Analysis Part 1 Cash Flow Analysis Part 2-Growth Part 3-Financing Part 3 Capite Structure Pat 3-MP B La Book Phy 12 AA Wrap Text Percentage Merge & Center %" Conditional Format Call Formatting as Table Styles Pasta 383 Calibri (Body) BIU fx SUM(068-067)/(D62) "E Output area: DO NOT TYPE in this box Cament 13 2.6% 10.2% $ 38,946,542 the projected 20% growth rate and the 535 millon increase in Fixed Assets in the pro forma input parameters box. Under these stumptions, how much 110PC need to implement the new production selected ratios and discus any significant changes that the projected growth and expansion investments Asume that the required extern fancing will come from Det thas been A Aher inputing the projected 20 percent growth rate and the 395 million increase in faxed assets in the pro forma input parameters calculated and determined the external financing that will be reeded to implement the new production line project will be $38,947,000 R. The SPDC ratios have taken a bit but nothing that wasn't expected because they would take los within the plans of the expansion With the company taking on debt to make the expansion work out this mesSFOC requires external financing shown above but these ratios exceed the industry median which showshow promising this company truly is Financial Statements Ready Part 1 FS Analysis M --E Insert Delete Part 1 Ratio Analysis Part 1 Cash Flow Analysis Part 2 - Growth Part 3-Financing Part 3-Capital Structure A Part 3-Debt Financing (Due at the end of Unit 5) D In the company fortunately achieved the bond financing needed through the 3 H Instructions: Compute the total amount of Bond financing needed for the expansion project. Bonds may only be issued in Face amounts $1,000. The Bond will pay semiannually with an annual Coupon rate of 3.5 %. The Market rate is 3%. Discuss your observations of the re Please refer to the Project Requirements for complete instructions. Per Bond information Face Number of Bonds issued $ 1,000 38,947 Coupon 3.5% Annual Coupon Payment per bond $ 35 Market Term (years) 3.0% 30 Purple cells require a formula Yellow cells only require data. a. How much total Bond financing is needed? b. At what price will the bonds trade after the initial issue? c. What are the company's total annual interest payments? d. What is the total market value of the bonds? $ 38,947,000 Note-this comes from Part 2 of the Project $1,098.45 $ 1,363,145 $ (42,781,358) e. Please discuss the implications of your calculations and why the market value and the actual proceeds from the bond issue are different. The implications of of my calculations resulted in the company fortunately achieved the bond financing needed through the 3.5 % coupon rate. If the commpany was not able to achieve the bonds at that rate they would have needed more bonds to achieve the financing needed to accomplish the special financing need for this project. Market value changes consistently but the company caught the coupon at a great time. Paste C66 B BIU 2b Wrap Text Merge & Centerv General $%9 Cell In Conditional Format Formatting as Table Styles fx B. The amount of financing needed for the bond issue will be $68,947,000.00 C. SPDC has the option of converting the financing into debt and using bonds for Part 3 Capital Structure (Due at the end of Unit 5) Instructions 1. Input the projected growth rate and getated project cost to the Input Parameters box. Note the new level of EFN 2. Using the new level of EFN, recompute the financial ratios assuming all of the EFN will come from Debs Round up to the nearest $1,000 Assume the Interest payments will be 3.5% of new debt 3. Discuss your results, and what other options for financing the company has Please refer to the Project Requirements for additional data and complete instructions. Output are: DO NOT TYPE in this box! P bond out w 2011 68,946,542 Financial Statements Part 1 FS Analysis Part 1 Ratio Analysis Part 1 Cash Flow Analysis Part 2-Growth Part 3 Financing Part 3-Capital Sta 15 G Paste lb C66 Calibri (Body) B I U v 14 AA Wrap Text Merge & Center General $1%9 Y Conditional For Formatting as fx B. The amount of financing needed for the bond issue will be $68,947,000.00 C. SPDC has the option of converting the financing into dell " 34 35 16 100,000 $8.847.000 Addand SOFC OPCAP Exp 11 ALIS 495 1075 1435 30m How much extra fencing the end What pens for fading shoes or ha 47,000.00 C SPDC has the option of converting the financing into debt and ung bends for the fancing D term Ranncial ratios of this company putting them below the industry median The seal franci this company move forward. This company would definitely be taking a hit financially. But growth and revenue increases The amount of francing needed) These options will effect the cach bond issue weather the star Part 3-Net Present Value (Due at the end of Unit 5) Instructions: 1. Compute the Net Working Capital cash flow required by the new production line. 2. Compute the expected Operating Cash Flow from the production line. 3. Using the above cash flow data, compute the NPV of the project cost using the final estimated cost. You must decide if the company will finance the entire project through del amount of Bonds and offer equity financing for the remaining financing needs. Be sure to use the appropriate projected interest payments. 4. Discuss your decision and the results. Please refer to the Project Requirements for additional data and complete instructions. Computs the Net Working Capital (NWC) cash flow Projected Revenue Beginning NWC Ending NWC NWC cash flow Year 3 Year 2 Year 3 $ S Purple ces requ Year 4 Year 5 Year 6 Yellow cats only #2 Compute the expected Operating Cash from the production line Year 1 Year 3 Year 4 Year 5 Projected Revenue Variable costs Fixed co Depreciation ENT Interest on Bonds CBT Tax (2) Net income OCF-EBIT Depesciation-Comme Operating Cash Flow Compute the NPV for the project Year O Year 1 Year 2 Year 3 Year 4 Year 5 Dow are its computed FCET Capital spending Net working capital cash flow Teminal value Financial Statements Part 1 FS Analy Part 1 Ratio Analysis Part 1 Cash Flow Analysis Part 2-Growth Part 3 Financing Part 3-Capital Structure Ready C21 17 12 19 Compute the expected Operating Cash Flow from the production e Projected Revenue Year 1 Variable costs Fed costs ENT Depreciation 25 Interest on Bonds EBT Tax (21 30 Net income OCF-EBIT + Depreciation-Cumet taxes Operating Cash Flow Compute the NPV for the project 36 00 Capital spending Networking capital cash flow Terminal value Total cash flows 41 PV factor 43 51 52 53 PV of amount NPV Descuts your decision and your results Year 2 Year 3 Merge & Center 28 98 Conditional Format Formatting as Table Styles Cell Insert Year S Year D Year 1 Year 2 Year 3 Year 4 Note there are no taxes tmp Financial Statements Part 1 FS Analysi Part 1 Rubio Analysis Part 1 Cash Flow Analysis Part 2-Growth Part 3 Financing Part 3-Capital Struct Ready