Newman has promised to pay all of it retained earnings as dividend in the amount of $12,000 over the next three years and then shut down (plan A). If the required rate of return on its common stock is 8% 

answer the following question. 

Show all the calculations clearly in the Excel file. If its investors require a dividend of $14,000 in the first two years, 

what strategy can the firm employ to fulfill that demand (plan B)? 

What is the dividend amount firm will pay in the final year? If its investors require a dividend of $10,000 in the first two years, what strategy can the firm employ to fulfill that demand (plan C)? 

What is the dividend amount firm will pay in the final year? Calculate the PV of the dividends for all three dividend plans.