Use the forecasted financial statements attached to finish the financial analysis of the statement of forecasted cash flows, and retained earnings by filling in the Yellow highlighted cells and finishing the Excel sheet for this project. Please show your work and Excel calculations during the process.

you are planning on building a plant that produces soybean meal and oil. It will take 12 months to construct costing $257.97 million. You are going to finance this with $85 million in equity, and $180 million in debt. This debt will be over 10 years at $20 million a year plus interest. The life of this plant will be 30 years.

(You need to account for the 30-year life even with only 10 years of cash flow statements and income statements)

Retained Earnings, and Statements of Operations forecasted

	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
	$0	$301,136,583	$602,273,166	$602,273,166	$602,273,166	$602,273,166	$602,273,166	$602,273,166	$602,273,166	$602,273,166
	$0	$287,389,370	$575,097,563	$575,560,255	$576,038,582	$576,038,582	$576,038,582	$576,038,582	$576,038,582	$576,038,582
	$2,799,990	$4,466,928	$9,200,073	$9,475,149	$9,759,403	$9,759,403	$9,759,403	$9,759,403	$9,759,403	$9,759,403
OPERATING INCOME	($2,799,990)	$9,280,285	$17,975,530	$17,237,762	$16,475,180	$16,475,180	$16,475,180	$16,475,180	$16,475,180	$16,475,180
INTEREST EXPENSE	$0	($3,982,496)	($7,360,056)	($6,553,474)	($5,746,893)	($5,746,893)	($5,746,893)	($5,746,893)	($5,746,893)	($5,746,893)
OTHER INCOME	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	($2,799,990)	$5,297,789	$10,615,474	$10,684,287	$10,728,288	$10,728,288	$10,728,288	$10,728,288	$10,728,288	$10,728,288
	$0	$264,889	$530,774	$534,214	$536,414	$536,414	$536,414	$536,414	$536,414	$536,414
	$0	$79,467	$159,232	$160,264	$160,924	$160,924	$160,924	$160,924	$160,924	$160,924
	($2,799,990)	$4,953,433	$9,925,469	$9,989,809	$10,030,949	$10,030,949	$10,030,949	$10,030,949	$10,030,949	$10,030,949
	$0	($2,799,990)	$2,153,443	$12,078,911	$22,068,720	$32,099,669	$42,130,618	$52,161,567	$62,192,516	$72,223,465
	$0	($2,000,000)	($4,000,000)	($4,000,000)	($4,000,000)	($4,000,000)	($4,000,000)	($4,000,000)	($4,000,000)	($4,000,000)
	($2,799,990)	$4,953,433	$9,925,469	$9,989,809	$10,030,949	$10,030,949	$10,030,949	$10,030,949	$10,030,949	$10,030,949
	($2,799,990)	$2,153,443	$12,078,911	$22,068,720	$32,099,669	$42,130,618	$52,161,567	$62,192,516	$72,223,465	$82,254,414
Depreciation, 20 years	($12,898,500)
Debt, Paid Back After Year 10	$180,000,000
Equity	$85,000,000
Capital Investment Annual	$2,000,000
Capital investment Initial	$257,970,000
Year 1: Construction
Year 2: 50% Operations
Year 3: 100% Operations

Find the Year 1 construction, year two 50% operations, and year 3 100% operations.

10 year forecasted cash flow statement

Find the DCF, NPV, IRR, Profit Index, Cum Cash Flow, Payback Period, Discounted Cum Cash Flow, and Discounted Payback Period.

Thank you very much!