please help me create the balance sheet in excel, please also show the formulas. The Fairfax Group excel is the base for the problem.

Problem 1: Use the discussion of Fairfax Group in the lecture posted in the practice section of the module on financial statements ("Fairfax-Example") and the associated Excel file (450 Fairfax homework solution.xlsx) as the base for the problem. Prepare proforma forecasts of financial statements of Fairfax Group for the next two years, 2018 and 2019. For your forecast, use the following specific assumptions: a) In 2018 and 2019, sales will grow at 15% per year; b) CGS to sales will grow by 0.5% in each of the next two years; c) SGA to sales will grow by 0.5% in each of the next two years; d) DRO and DPO will be maintained at 2016 level; e) DSI will be maintained at 2016 level; f) The company needs to maintain a minimum cash balance equal to 5% of its total assets; g) Equipment already in place as of the end of 2017 is depreciated at the rate of $900,000 per year; h) Capital expenditures for the purchase of additional equipment amount to $750,000 in each of the next two years (in 2018 and separately in 2019). That new equipment is depreciated straight-line over 10 years to the salvage value of zero; i) The company maintains a constant payout ratio of 30% of Net Earnings in each of the next two years; j) Tax rate is reduced to 21%; k) The company's main and only source of financing is the line of credit from the bank at 10% per year until 5 million dollar limit. The company has an agreement with the bank that it may borrow over the 5 million dollar limit. The annual interest rate increases to 15% per year for any amount that the company borrows over the limit; 1) Other accounts will be maintained at ratios to sales similar to those during 2017; Make sure the balance sheet is balanced. Answer the followina cnarification