I need help solving this financial problem immediately. Solve for EPS, FFO, and ROC using both approaches. (In Excel)

Robust Properties is planning to go public by creating a REIT that will offer 1 million shares of stock. It is currently trying to develop a pro forma set of financial statements. Robust is faced with a number of questions about its handling of some accounting and financial disclosure issues. The management of Robust Properties has asked you to prepare preliminary pro forma financials for the next three years. Specifically, you should have (1) a beginning balance sheet, (2) operating statements for each of the next three years, and (3) all relevant financial ratios for year 1 results only. Robust will pay all financing fees, tenant improvements, and lease commissions upon commencing operations. It would like to pay a minimum dividend of $4.00 per share. In preparing your pro forma operating statements, Robust wants you to consider the effects of reporting in the following two ways: a. What would EPS, FFO, and ROC be under both approaches? (Round your intermediate calculations and final answers to 2 Required: The management of Robust Properties has asked you to prepare preliminary pro forma financiais for the next three years. Specifically, you should have (1) a beginning balance sheet, (2) operating statements for each of the next three years, and (3) all relevant financial ratios for year 1 results only. Robust will pay all financing fees, tenant improvements, and lease commisslons upon commencing operations. It would like to pay a minimum dividend of $4,00 per share. In preparing your pro forma operating statements, Robust wants you to consider the effects of reporting in the following two ways: Required: a. What would EPS, FFO, and ROC be under both approaches? (Round your intermediate calculations and final answers to 2 decimal places.)