please use excel sp

Fairfield Office Supplies Inc. has a regional chain of office supply stores in the Midwest. Fairfield is trying to compete with the large nationwide office supply companies. It is January of 2023 and Fairfield needs to make some capital budgeting decisions this year. They need to decide whether to replace their computerized inventory system or upgrade the old one, whether to purchase two stores from a sole proprietor or not, whether to keep, abandon or modernize one of the stores, which new copiers to purchases and a few other small projects. The company is under some pressure and has a strict capital budget of $10 million, so they need to be careful as to which projects they choose. Examine the following book-value balance sheet for Fairfield Office supplies for the year 2022. What is the capital structure of the firm based on market values? The preferred stock currently sells for $7.00 per share and the common stock for $16.00 per share. The preferred stock pays a dividend of $.70 per share, the Common Stock paid a dividend of $1.10 last year, and the firm is expected to continue to grow at the same rate as the net income for the past five years, The rate on 90 day treasuries is 1.50%, the beta of the stock is 1.45 , the market risk premium is 8%, and the firm's tax rate is 40%. The float costs are as follows: Debt: 10% of par only for the amount borrowed under $1.1 million (after that it is 0% ), preferred: $0.6 per share and Common: $1.75 per share. The firm has paid out 30% of its net income as dividend in the past five years and is expected to continue. If the company borrows over $1.1 million then the cost of debt goes from 9.0% to 11% (including flotation) and if the company borrows over $2.2 million the cost goes to 13% (including flotation). Find the Marginal costs of capital for Fairfield. Fairfield tax rate is 40%. (For Required return of retained earnings use an average of the DCF method and the CAPM method). \begin{tabular}{|l|l|l|l|l|l|} \hline Years & 2022 & 2021 & 2020 & 2019 & 2018 \\ \hline NetIncome(inmillions) & 5.11 & 4.80 & 4.40 & 4.10 & 3.90 \\ \hline \end{tabular} Replacement or upgrade of the computerized inventory system: The current system is 3 years old, originally cost $1,100,000, is being depreciated on a straight-line basis over its five year life and has an estimated salvage value of $100,000. Although the system is being depreciated over 5 years, it could last for 5 more years. If the machine was sold today, it would be for $325,000. The new system would cost $1,275,000, including installation costs, and would be depreciated on a straight-line basis over its five year life to a salvage value of $125,000. Fairfield spent $100,000 last year researching this new system. This new system would reduce cash operating costs by $310,000 per year. Inventory needs are expected to increase by $70,000 immediately due to the new system, but accounts payable will rise by $15,000. At the end of the life of this machine inventory and accounts payable will reverse. Both machines will be sold at their salvage value at the end of the five year project. Should the company recommend replacement or upgrade the system? Fairfield Office Supplies Inc. has a regional chain of office supply stores in the Midwest. Fairfield is trying to compete with the large nationwide office supply companies. It is January of 2023 and Fairfield needs to make some capital budgeting decisions this year. They need to decide whether to replace their computerized inventory system or upgrade the old one, whether to purchase two stores from a sole proprietor or not, whether to keep, abandon or modernize one of the stores, which new copiers to purchases and a few other small projects. The company is under some pressure and has a strict capital budget of $10 million, so they need to be careful as to which projects they choose. Examine the following book-value balance sheet for Fairfield Office supplies for the year 2022. What is the capital structure of the firm based on market values? The preferred stock currently sells for $7.00 per share and the common stock for $16.00 per share. The preferred stock pays a dividend of $.70 per share, the Common Stock paid a dividend of $1.10 last year, and the firm is expected to continue to grow at the same rate as the net income for the past five years, The rate on 90 day treasuries is 1.50%, the beta of the stock is 1.45 , the market risk premium is 8%, and the firm's tax rate is 40%. The float costs are as follows: Debt: 10% of par only for the amount borrowed under $1.1 million (after that it is 0% ), preferred: $0.6 per share and Common: $1.75 per share. The firm has paid out 30% of its net income as dividend in the past five years and is expected to continue. If the company borrows over $1.1 million then the cost of debt goes from 9.0% to 11% (including flotation) and if the company borrows over $2.2 million the cost goes to 13% (including flotation). Find the Marginal costs of capital for Fairfield. Fairfield tax rate is 40%. (For Required return of retained earnings use an average of the DCF method and the CAPM method). \begin{tabular}{|l|l|l|l|l|l|} \hline Years & 2022 & 2021 & 2020 & 2019 & 2018 \\ \hline NetIncome(inmillions) & 5.11 & 4.80 & 4.40 & 4.10 & 3.90 \\ \hline \end{tabular} Replacement or upgrade of the computerized inventory system: The current system is 3 years old, originally cost $1,100,000, is being depreciated on a straight-line basis over its five year life and has an estimated salvage value of $100,000. Although the system is being depreciated over 5 years, it could last for 5 more years. If the machine was sold today, it would be for $325,000. The new system would cost $1,275,000, including installation costs, and would be depreciated on a straight-line basis over its five year life to a salvage value of $125,000. Fairfield spent $100,000 last year researching this new system. This new system would reduce cash operating costs by $310,000 per year. Inventory needs are expected to increase by $70,000 immediately due to the new system, but accounts payable will rise by $15,000. At the end of the life of this machine inventory and accounts payable will reverse. Both machines will be sold at their salvage value at the end of the five year project. Should the company recommend replacement or upgrade the system