Please show excel work if possible!

Autos AECO- International Traders Home Insert Draw Design Layout References Mailinge Review View Tell me Share Comments Times Now. 12 AA C :. A ABCDE ca dakan Cnsel AaBCDBCE Hessing Receb AaBb AB The No Space dada thrph. B x A 22 x Irin. Giorg Dictate Sensitivity EHE Styles Parc Assignment Exumald International Traders is an expanding conglomerale, is a culturing company whose product lines consist of lighting fixtures, videndises, electrcmic timing devices, vel agencies, and self-storage space. Dollar was considering trying some shares for the find she managed, the New Point Large np Fund with an emphasis on value investing Interntional Traders Corp's Analyst bas projected the following cash flows and growth ralex Ir the next five years (in trillions of dollars): Pro Forma Income Statement 2019 2020 2021 2022 202.3 Growth Rate 0.2 0.2 0.15 0.1 0.03 Net sules S550 $660.0) $759.0 5835.C $ $877.0 Coat of goods sold (70%) (S383.0) (5462.0) ($531.0) ($384.0) ( (5614.0) Selling ministrative expenses (20%) ($110.0)|($132.0) ($151.8) ($167.0) ($175.4) Dipuociation (8%) (S44.0) ($52.8) 1 ($60.71 (566,8) (S70.2) | SILO $11.2 515.2 $ $16.7 $17.5 Lotcrcat { (S5.0) (160) (18.0) ($10.0) (S10.0) | S6.0 $72 $72 56.7 $7.3 Taxes (10%) (S18) ( (522) ($2.21 (S2.0) (S2.1) Not incomo S4.2 $3.0 $3.0 S4.7 $5.3 All cash flows above are assumed to occur at cod-of-year, and it is cuposted to grow at rate of 5% after 2023. International Trailers currently has a market value capital structure of 20 percent tleht with interest Tite 10/% and a beta af 2. Demreciation schedule is 8 percent of net sales and the finds to replace Wi-cut equipment is percent of net sales The company has 3 million alarcs, S50 million debt and $ 30 million in casli. The risk- free rate is 3 pace and their arkut tisk premium is 6 percent. Aswer the following questions 1. What is the value and price per share based on WACC Motlel? What is the value and price per shate hasel on free cash floya tr> equity (FCFT:)? 3. Whar is the vahie nnd price per share based on adjusted present value (APV) Lo stanhalus Page 1 of 1 293 word: * English (Unted States Focus 2 C = - + 21N = Autos AECO- International Traders Home Insert Draw Design Layout References Mailinge Review View Tell me Share Comments Times Now. 12 AA C :. A ABCDE ca dakan Cnsel AaBCDBCE Hessing Receb AaBb AB The No Space dada thrph. B x A 22 x Irin. Giorg Dictate Sensitivity EHE Styles Parc Assignment Exumald International Traders is an expanding conglomerale, is a culturing company whose product lines consist of lighting fixtures, videndises, electrcmic timing devices, vel agencies, and self-storage space. Dollar was considering trying some shares for the find she managed, the New Point Large np Fund with an emphasis on value investing Interntional Traders Corp's Analyst bas projected the following cash flows and growth ralex Ir the next five years (in trillions of dollars): Pro Forma Income Statement 2019 2020 2021 2022 202.3 Growth Rate 0.2 0.2 0.15 0.1 0.03 Net sules S550 $660.0) $759.0 5835.C $ $877.0 Coat of goods sold (70%) (S383.0) (5462.0) ($531.0) ($384.0) ( (5614.0) Selling ministrative expenses (20%) ($110.0)|($132.0) ($151.8) ($167.0) ($175.4) Dipuociation (8%) (S44.0) ($52.8) 1 ($60.71 (566,8) (S70.2) | SILO $11.2 515.2 $ $16.7 $17.5 Lotcrcat { (S5.0) (160) (18.0) ($10.0) (S10.0) | S6.0 $72 $72 56.7 $7.3 Taxes (10%) (S18) ( (522) ($2.21 (S2.0) (S2.1) Not incomo S4.2 $3.0 $3.0 S4.7 $5.3 All cash flows above are assumed to occur at cod-of-year, and it is cuposted to grow at rate of 5% after 2023. International Trailers currently has a market value capital structure of 20 percent tleht with interest Tite 10/% and a beta af 2. Demreciation schedule is 8 percent of net sales and the finds to replace Wi-cut equipment is percent of net sales The company has 3 million alarcs, S50 million debt and $ 30 million in casli. The risk- free rate is 3 pace and their arkut tisk premium is 6 percent. Aswer the following questions 1. What is the value and price per share based on WACC Motlel? What is the value and price per shate hasel on free cash floya tr> equity (FCFT:)? 3. Whar is the vahie nnd price per share based on adjusted present value (APV) Lo stanhalus Page 1 of 1 293 word: * English (Unted States Focus 2 C = - + 21N =