The project requires to complete an Excel$-$based financial model template. Such models are

extensively used in business planning, decision$-$making, and for obtaining business financing.,

making but also emphasizes critical thinking and general business skills. Specifically, the case

has the following objectives: $(1)$ to obtain experience using Excel within a planning and decision

context; $(2)$ to integrate a range of managerial and financial accounting concepts; and $(3)$ to

reinforce financial statement relationships through linking projected financial statements.

You will complete a financial planning model that is derived from a set of assumptions and link

together statements of projected cash, income and balance sheets that articulate. An Excel

template, which is available for downloading, is structured with a separate worksheet $($or tab$)$ for

each of the following sections: Sheet $(1)$ Assumptions; Sheet $(2)$ Supporting Schedules; Sheet $(3)$

Projected Income Statement and Balance Sheet; and Sheet $(4)$ Projected Cash Flow.

Sheet $(2)$ provides supporting schedules for detailed computations, which in turn links to the

projected income statements and balance sheet contained within Sheet $(3),$ along with projected

cash flow in Sheet $(4).$

$1$