I need help with topic 6, 7, and 8. Please help me with this!
Instructions 1. Save your completed MS Excel document (template) using the following file naming convention: FinalAssessmentLastNameFirstName 2. The instructor will make this final course assessment available to the class on the day and in the manner indicated in the course syllabus. Not later than the due date and time indicated in the course syllabus, (i) complete the assessment according any further directions stated below and (ii) submit it in the manner (via the Course Dropbox tool or RegisNet email using INsite) set forth in the Facilitator Expectations posting. Five problems/questions comprise the final course assessment with maximum point values indicated below: Topic 5- Net Present Value Analysis 6- Capital Budgeting and Cost of Capital 7- Working Capital Management 8- Financial Ratio Analysis 9- Projected Final Statements and Financing Requirements Total: Maximum Your Points Possible Points Earned Estimated Minutes Required To Complete 20 20 20 20 20 100 0 Students must complete this assessment individually, not in collaboration with others. The course syllabus sets forth the university's academic integrity policy and the various sanctions that the university may impose on students for violations of that policy, including use of inappropriate sources of information on examinations. Topic 5 (20 points) The CEO of Midwest Manufacturing Company has asked for your analysis of and recommendation related to the proposed acquisition of an additional stamping machine for its principal manufacturing plant. Demand for the company's products has risen to a level that exceeds its present productive capacity. An additional stamping machine will make it possible for the company to increase its production and sales by 15 percent, resulting in projected incremental relevant cash flows (after income taxes and the tax benefits of the \"depreciation tax shield\") in each of the next five years, as indicated in the Table 1 shown below: The equipment will cost $100,000 to purchase and install. Management estimates that its economic life will be five years, after which it will have no residual value. The company's required rate of return on new investments (cost of capital) is 11.0 percent (or, 0.11). Complete the NPV analysis of the stamping machine proposal, below. Regard all incremental relevant cash flows as \"risky\" and assume they occur at the end of years indicated, as listed above. State your recommendation to the CEO, including the basis for it. Limit the length of your response to 50 words Year 1 2 3 4 5 17F8W1 Table 1 Projectd Cash Flows $10,000 $30,000 $40,000 $30,000 $20,000 Additional Given Information from above: Initial Cost = $100,000 Cost of Capital = 11% a. Complete the NPV analysis of the stamping machine proposal: Year (n) \"Time zero\" 1 2 3 4 5 NPV Relevant cash flow Discount factor Discounted cash flows b. State your recommendation to the CEO, including the basis for it. Limit the length of your response to 50 words. Replace this text with your response Topic 6 (20 points) The VP-Operations of Midwest Manufacturing Company has asked for your review of her capital budgeting analysis, comparing two alternative machines the company is considering acquiring for one of its plants. Using the information provided in the table below, complete her analysis by computing the company's cost of equity capital, rE, weighted average cost of capital, rWACC, and the equivalent annual cost (EAC) for each machine under consideration. State your recommendation to the VP with regard to selecting one of these machines. Given From Above rE = ? rWACC = ? B = 1.8 rD = 9.50% t = 40% rM = 12.50% rF = 4% D= 50% E = 50% NPV (X) = $281,400 NPV (Y) = $230,300 Life(X) 10 Life(Y) 7 Complete Parts A, B, C, and D On The Next Page 17F8W1 a. Compute the company's cost of equity capital, rE. Show computations in good form and label properly all amounts presented. b. Compute the company's weighted average cost of capital, rWACC. Show computations in good form and label properly all amounts presented. c. Compute the equivalent annual cost (EAC) for each machine under consideration, ignoring \"cost recovery\" income tax deductions, the tax deductibility of ownership costs, and capital gains taxes upon the machine's disposal). Show computations in good form and label properly all amounts presented. Machine X Machine Y d. State your recommendation to the VP-Operations, including the basis for it, in the box below. Limit the length of your response to 50 words. Topic 7 (20 points) The VP-Sales and Marketing of Midwest Manufacturing Company has asked for your analysis of her proposal to modify the company's current terms of sale, \"2/10, net/30.\" She has proposed more generous terms - \"3/10, net/30\" - in order to promote increased sales and market share. She has acknowledged that more generous terms may also lead to increased bad debts. The business' operating budget for the forthcoming fiscal year includes the following relevant information: Budgeted unit sales, Q18,000,000 units Budgeted unit selling, SP $15 per unit Budgeted bad debts, BD1, as percent of sales 0.01 (or, 1.0 percent) Budgeted unit variable cost, VC (excluding BD1) $8 per unit Combined effective income tax rate, t 0.40 (or, 40.0 percent) Current interest rate on business' debt, rD 0.12 (or, 12.0 percent) In addition, based on the existing terms of sales: Discount percentage, CD1 0.02 (or, 2.0 percent) Discount period, DP1 10days Under the proposed terms of sales: Discount percentage, CD2 0.03 (or, 3.0 percent) Discount period, DP2 10 days Estimated bad debts, BD2, as percent of sales 0.015 (or, 1.5 percent) 17F8W1 Given from above Q1 = 8,000,000 SP = $15 BD1 = 1% VC = $8 t= 40.00% rD = 12.00% CD1 = 2.00% DP1 = 10 CD2 = 3.00% DP2 = 10 BD2 = 1.5000% Complete Parts A & B days days On The Next Page a. Compute the NPV of the company's existing terms of sales based on its operating budget and other information provided, above. Show computations in good form and label properly all amounts presented. b. Compute the required sales volume, Q2, under the proposed terms of sale necessary to achieve the NPV of the existing credit policy - i.e., the \"break even\" unit sales volume. Show computations in good form and label properly all amounts presented. of her proposal to terms - \"3/10, more generous ng fiscal year Topic 8 (20 points) Demonstrate your ability to apply financial ratio analysis to common-sized financial statements. Analyze the common-sized balance sheet and income statement of FirstRate Company, included in the Topic 8 background paper, Financial Ratio Analysis. Identify the most significant: Trends in the 20X0 - 20X4 common-sized financial information, and Differences between the common-sized financial information of the company and its industry's norms Your analysis should indicate the basis on which you indentified trends or differences as significant, including the potential implications for FirstRate's business or financial condition. Limit your response to a maximum of 200 words. Spell-check and-grammar-and-stylecheck your completed response using MS Word's tool for this purpose, being sure to correct any matters identified by these checking tools. Please provide your word count here Your response here (please do not modify the formatting, fonts, colors, and so forth in this document template) Topic 9 (20 points) The CEO of Southwest Manufacturing Company has asked you to (a) complete the projected income statement and projected balance sheet for the coming fiscal year (FY) of the company using the information set forth below. She has also asked you to (b) determine the amount of any additional external financing the company will require during the coming fiscal year and (c) assess the reasonableness of the projections in relation to the company's estimated cost of equity capital, r E, and its sustainable sales growth rate. Use the average gross margin during the preceding two-year period to project the amount of gross profit. Use the average ratio of "all other S&A-to-sales revenue" during the preceding two-year period to project the amount of all other S&A expense. Use the average amount of R&D expense during the two preceding FYs to project the amount of this expense. The estimated combined effective income tax rate during the projected FY is 0.40 (40%). Project the balances of cash and cash equivalents, total current assets, and total liabilities as \"residual amounts\" using the general methodology examined in Topic 9 of the course. Project total assets using the projected balance of total liabilities and shareholders' equity. Project the balance of total liabilities and stockholders' equity based on projected total stockholders' equity and a targeted total debt ratio (ratio of total liabilities-to-total stockholders' equity) of 0.70 (70%). Project the balance of accounts receivable (AR) using a projected average AR collection period ratio of 45 days. Project the balance of inventory using a projected average days to sell inventory ratio of 90 days. Project the balance of other assets using the average balance of this item during the two preceding FYs. Project the balance of accounts payable (AP) using projected "cash costs" and a projected average AP payment period of 45 days. "Cash costs" include projected COGS and operating expenses, excluding depreciation. Project the balance of dividends payable as the dividends that the company expects to declare during the final week of the projected FY (based on net income for that year) and pay early in the next FY. The company's payout ratio (dividend policy) is 0.40 (40%). The company plans no issuances (or repurchases) of common stock during the projected FY. Project retained earnings (RE) using projected net income and projected dividends to be declared near the end of the projected FY. The company's estimated cost of equity capital, rE, is 0.185 (18.5 percent), computed using CAPM as: rF + x (rM - rF) = 0.04 + 1.7 x (0.125 - 0.04) Complete Parts A, B, and C On The Following Pages Given Information: Tax Rate Ave Coll Period AVE Days In Inventory AVE AP Period Payout Ratio Debt Ratio 40% 45 90 45 40% 70% a. Projected income statement Actual (historical) 20X0 (A) Sales revenue 20X1 ### Projected 20X2 ### ### 7,200,000 7,500,000 8,000,000 Cost of goods sold (COGS): (B) Deprec. of manufacturing PP&E (C) All other COGS (D) Total COGS ### ### -7,200,000 ### (E) Gross profit ### ### (F) Gross margin 31.00% 33.00% Operating expenses: (G) (H) (I) (J) (K) (L) (M) (N) Selling and admin. (S&A) exp.: Deprec. of non-mfg $274,000 PP&E All other S&A expense 6,348,000 Research and devel. (R&D) 1,500,000 exp. Other operating expenses 178,000 Total operating 8,300,000 expenses Operating income 8,100,000 Interest on debt 391,000 6,666,000 1,700,000 173,000 9,400,000 -620,000 -760,000 -846,666 20,000 20,000 20,000 (P) 7,500,000 8,500,000 (Q) Provision for income taxes 3,000,000 3,400,000 (R) Net income a. (continued) Projected balance sheet Assets: Current assets: (A) Cash and cash equivalents (B) Investment securities (C) Accounts receivable (D) Inventory (E) Total current assets Current Ratio 240,000 8,930,000 Income from investments Gain (loss) on PP&E disposals Income before taxes (O) $500,000 - -160,000 - ### 5,100,000 Actual (historical) Projected 20X0 20X1 20X2 $440,000 435,000 400,000 400,000 400,000 6,610,000 6,940,000 9,130,000 9,310,000 16,580,000 17,085,000 1 1 (F) (G) (H) (I) (J) (K) (L) (M) (N) (O) (P) PP&E, at cost Accumulated depreciation of PP&E PP&E, net Other assets Total assets Liabilities: Current liabilities: Accounts payable Accrued income taxes payable Dividends payable Bank notes payable - current Accrued interest payable Total current liabilities (Q) (R) (S) (T) (U) (V) (W) 17F8W1 Bank notes payable - noncurrent Total liabilities Total debt ratio Stockholders' equity: Common stock, at par Additional paid-in capital Retained earnings Total stockholders' equity Total liab. and stockhldrs' equity 42,920,000 16,470,000 26,450,000 900,000 $43,930,000 50,485,000 22,710,000 27,775,000 1,100,000 45,960,000 $4,670,000 750,000 1,800,000 9,200,000 160,000 16,580,000 4,780,000 850,000 2,040,000 9,230,000 190,000 17,090,000 4,590,000 21,170,000 0.93 3,050,000 20,140,000 0.78 14,220,000 3,180,000 5,360,000 22,760,000 $43,930,000 14,220,000 3,180,000 8,420,000 25,820,000 45,960,000 b. Determine the amount of any additional external financing the company will require during the coming FY. Show computations in good form and label properly all amounts presented. 58,900,000 28,900,000 880,000 9,860,000 210,000 c. Assess the reasonableness of the projected financial statements in relation to the company's estimated cost of equity capital, rE, and its sustainable sales growth rate. Actual (historical) 20X0 Return on average common equity (ROCE) ratio Net income (available to common stockholders) Projected 20X1 21.00% 21.00% $4,500,000 5,100,000 Total stockholders' equity, beginning of FY 20,060,000 ### Total stockholders' equity, end of FY 22,760,000 ### Average total stockholders' equity 20X2 $21,410,000 ### Sustainable rate of sales growth Net income (available to common stockholders) Beginning-of-year shareholders' equity Payout ratio Assessment of projected ROCE and sustainable growth rate in sales ratios (limit your response below to a maximum of 100 words): Computational Notes (Formulas or equations used) Given Given Given Given Given Given Given Computational Notes (Formulas or equations used) Given Given Given Given Given Given Present value interest factor of $1 per period at i% for n periods, PVIF(i,n). Period 1% 2% 3% 4% 5% 6% 7% 8% 9% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 2 0.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.842 3 0.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 4 0.961 0.924 0.888 0.855 0.823 0.792 0.763 0.735 0.708 5 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.681 0.650 6 0.942 0.888 0.837 0.790 0.746 0.705 0.666 0.630 0.596 7 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.583 0.547 8 0.923 0.853 0.789 0.731 0.677 0.627 0.582 0.540 0.502 9 0.914 0.837 0.766 0.703 0.645 0.592 0.544 0.500 0.460 10 0.905 0.820 0.744 0.676 0.614 0.558 0.508 0.463 0.422 11 0.896 0.804 0.722 0.650 0.585 0.527 0.475 0.429 0.388 12 0.887 0.788 0.701 0.625 0.557 0.497 0.444 0.397 0.356 13 0.879 0.773 0.681 0.601 0.530 0.469 0.415 0.368 0.326 14 0.870 0.758 0.661 0.577 0.505 0.442 0.388 0.340 0.299 15 0.861 0.743 0.642 0.555 0.481 0.417 0.362 0.315 0.275 16 0.853 0.728 0.623 0.534 0.458 0.394 0.339 0.292 0.252 17 0.844 0.714 0.605 0.513 0.436 0.371 0.317 0.270 0.231 18 0.836 0.700 0.587 0.494 0.416 0.350 0.296 0.250 0.212 19 0.828 0.686 0.570 0.475 0.396 0.331 0.277 0.232 0.194 20 0.820 0.673 0.554 0.456 0.377 0.312 0.258 0.215 0.178 25 0.780 0.610 0.478 0.375 0.295 0.233 0.184 0.146 0.116 30 0.742 0.552 0.412 0.308 0.231 0.174 0.131 0.099 0.075 35 0.706 0.500 0.355 0.253 0.181 0.130 0.094 0.068 0.049 40 0.672 0.453 0.307 0.208 0.142 0.097 0.067 0.046 0.032 50 0.608 0.372 0.228 0.141 0.087 0.054 0.034 0.021 0.013 ds, PVIF(i,n). 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.826 0.812 0.797 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.751 0.731 0.712 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.683 0.659 0.636 0.613 0.592 0.572 0.552 0.534 0.516 0.499 0.621 0.593 0.567 0.543 0.519 0.497 0.476 0.456 0.437 0.419 0.564 0.535 0.507 0.480 0.456 0.432 0.410 0.390 0.370 0.352 0.513 0.482 0.452 0.425 0.400 0.376 0.354 0.333 0.314 0.296 0.467 0.434 0.404 0.376 0.351 0.327 0.305 0.285 0.266 0.249 0.424 0.391 0.361 0.333 0.308 0.284 0.263 0.243 0.225 0.209 0.386 0.352 0.322 0.295 0.270 0.247 0.227 0.208 0.191 0.176 0.350 0.317 0.287 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.319 0.286 0.257 0.231 0.208 0.187 0.168 0.152 0.137 0.124 0.290 0.258 0.229 0.204 0.182 0.163 0.145 0.130 0.116 0.104 0.263 0.232 0.205 0.181 0.160 0.141 0.125 0.111 0.099 0.088 0.239 0.209 0.183 0.160 0.140 0.123 0.108 0.095 0.084 0.074 0.218 0.188 0.163 0.141 0.123 0.107 0.093 0.081 0.071 0.062 0.198 0.170 0.146 0.125 0.108 0.093 0.080 0.069 0.060 0.052 0.180 0.153 0.130 0.111 0.095 0.081 0.069 0.059 0.051 0.044 0.164 0.138 0.116 0.098 0.083 0.070 0.060 0.051 0.043 0.037 0.149 0.124 0.104 0.087 0.073 0.061 0.051 0.043 0.037 0.031 0.092 0.074 0.059 0.047 0.038 0.030 0.024 0.020 0.016 0.013 0.057 0.044 0.033 0.026 0.020 0.015 0.012 0.009 0.007 0.005 0.036 0.026 0.019 0.014 0.010 0.008 0.006 0.004 0.003 0.002 0.022 0.015 0.011 0.008 0.005 0.004 0.003 0.002 0.001 0.001 0.009 0.005 0.003 0.002 0.001 0.001 0.001 0.000 0.000 0.000 20% 0.833 0.694 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 0.135 0.112 0.093 0.078 0.065 0.054 0.045 0.038 0.031 0.026 0.010 0.004 0.002 0.001 0.000
