Prepare the calculations in excel and upload the file. Castillo Products Company The Castillo Products Company was started in 2017. The company manufactures components for personal digital assistant (PDA) products and for other handheld electronic products. A difficult operating year, 2018, was followed by a profitable 2019. The founders (Cindy and Rob Castillo) are interested in estimating their cost of financial capital because they are expecting to secure additional external financing to support planned growth. Short-term bank loans are available at an 8 percent interest rate. Cindy and Rob believe that the cost of obtaining long-term debt and equity capital will be somewhat higher. The real interest rate is estimated to be 2 percent, and a long-run inflation premium is estimated at 3 percent. The interest rate on long-term government bonds is 7 percent. A default-risk premium on long-term debt is estimated at 6 percent; plus Castillo Products is expecting to have to pay a liquidity premium of 3 percent due to the illiquidity associated with its long-term debt. The market risk premium on largefirm common stocks over the rate on long-term government bonds is estimated to be 6 percent. Cindy and Rob expect that equity investors in their venture will require an additional investment risk premium estimated at two times the market risk premium on large-firm common stocks. Following are income statements and balance sheets for the Castillo Products Company for 2018 and 2019. Castillo Products Company (Continued) A. Calculate the net profit margin, total-sales-to-total-assets ratio, the equity multiplier, and the return on equity for both 2018 and 2019 for the Castillo Products Corporation. Describe what happened in terms of financial performance between the two years. B. Estimate the cost of short-term bank loans, long-term debt, and common equity capital for the Castillo Products Corporation. C. Although, Castillo Products paid a low effective tax rate in 2019, a 30 percent income tax rate is considered more appropriate when looking to the future. Estimate the after-tax cost of short-term bank loans, long-term debt, and the venture's common equity. D. Estimate the weighted average cost of capital (WACC) for the Castillo Products Corporation using the book values of interest-bearing debt and stockholders' equity capital at the end of 2019 E. Cindy and Rob estimate that the market value of the common equity in the venture is $900,000 at the end of 2019. The market values of interest-bearing debt are judged to be the same as the recorded book values at the end of 2019. Estimate the market value-based weighted average cost of capital for Castillo Products. F. Would you recommend to Cindy and Rob that they use the book value-based WACC estimate or the market valuebased WACC estimate for planning purposes? Why