Two friends Harley and Davidson agree on a company deal with an implied enterprise value of $5M. Harley invests $3M. The deal is structured as all-common, and American Private Equity comes in and offers $8.5M million for the company. Harley owns 60% and Davidson owns 40%.

a. Set up the All-Common structure for the two partners. Calculate the payout table and discuss

b. If the deal is structured as redeemable preferred with $1,000 cheap common for the two partners, calculate the payout table and discuss

c. The deal is Convertible Preferred for the two partners. Calculate the payout table and discuss

Please answer the above with steps in excel