Obtain experience using excel within a planning

Assignment Help Other Subject

Reference no: EM133947869

FINANCIAL PLANNING AND MODELING CASE

GENERAL INSTRUCTIONS: READ THIS ENTIRE ASSIGNMENT CAREFULLY

BEFORE STARTING YOUR WORK. Failure to follow the instructions will result in point deductions. Late Projects will be subject to a 10 point for each day (or a fraction of a day) and will not be accepted after the third day following the deadline.

PROJECT OBJECTIVES
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. Get online assignment help – 100% Original & AI-Free Content.

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).

To work correctly, all cells of your model should be linked together via formulas, or cell references, across all worksheets. (A 5th sheet labeled, Graph contains data to produce a cost- volume-profit graph from current period, baseline information. You should use the ChartWizard in Excel to create the graph. The Excel template already contains the key assumptions as well as some formulas.

Within a real-life practice situation, you would need to independently develop and obtain support for the necessary assumptions that have been provided to you. In Part I of the Excel case, you should complete the model formulas and linkages to Sheets (2), (3) and (4

To accomplish this, the financial model must articulate (i.e., interconnect, or link) across all schedules and statements. Thus, a change in assumption should flow through and automatically update all related schedules in Sheet (2) and projected statements in Sheets (3) and (4). This requires entering formulas within the cells to calculate the required values, rather than hardcoding values into the cells.

Reference no: EM133947869

Questions Cloud

How can we reframe the bad in people : How can we reframe the bad in people to view them through a less discriminatory and more inclusive, humanistic lens - what is the first step that a person

Experiencing cerebrovascular accident : List the clinical manifestations that someone experiencing a cerebrovascular accident (CVA) is likely to experience

How a organizational culture is defined as or could be : Having trouble with my Management class not too sure on just what or how a Organizational Culture is defined as or could be?

Which agents would you be likely to be successful in your tx : Karen, a 49-year-old Caucasian female with pale skin and HX of easy. Which agents would you be likely to be successful in your TX of this common skin lesion?

Obtain experience using excel within a planning : Obtain experience using Excel within a planning and decision context; (2) to integrate a range of managerial and financial accounting concepts

What type of headache was joe experiencing : He was nauseous and very sensitive to light and sound. This lasted for several hours. What type of headache was Joe experiencing?

Explain the behavior and correlating perception driving you : Be sure to clearly explain the behavior and the correlating perception driving you.

What could be causes for antibiotic resistance in patient : What could be the causes for antibiotic resistance in a patient? As a nurse, what interventions should I perform on the patient to avoid antibiotic resistance?

Stereotypes about the elderly-considering physiological : Discuss these stereotypes about the elderly, considering physiological, pathological and psychosocial changes and how they may impact on the individual

User Account

All Pages