Reference no: EM131493929

The Financials

This exercise is considered an academic writing exercise. Quality of response, grammar, and punctuation are considered in your overall grade.

This exercise does not require the use of APA format or a cover page.

This exercise uses the "Business Plan Financials" MS Excel template. Use the "Business Plan Financials Guide" to assist you in completing the required worksheets. (Both documents are also available in the Course Required Files in Week 1.)

It is recommended that students construct their deliverable(s) using MS Word / MS Excel and then attach the document(s) to the discussion thread submission area in Blackboard.

Use the "NAB Company Portfolio" (see: Course Required Files in Week 1) for reference. Provide the following information below.

For year one of your NAB company's Business Plan, complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the "Business Plan Financials" MS Excel template (see: Course Required Files in Week 1). Note:Attach the MS Excel worksheet to the discussion thread.

Hints: Your marketing costs should already be included as you created your Marketing Budget in Week 4 and those will be filled in automatically.

Hints: Use the figures you arrived at in the operations and technology sections of your plan to help fill out your financial forms.

Hints: Work through the worksheets in order. The excel worksheets will automatically enter the numbers into your Income Statement.

Develop the following financial sections of your NAB company's Business Plan.

Note:Attach the MS Word document to the discussion thread.

Sources and use of funds

Plan assumptions

Break-even analysis

Provide constructive feedback to at least one (1) classmate's post.see bellow

The statement of cash flows is very important to investors because it shows how much actual cash a company has generated. Wiley & Sons state,

"The Three Elements of the Statement of Cash Flows"

Because companies can generate and use cash in several different ways, the statement of cash flows is separated into three sections: cash flows from operating activities, from investing activities, and from financing activities.

The cash flows from operating activities section shows how much cash the company generated from its core business, as opposed to peripheral activities such as investing or borrowing. Investors should look closely at how much cash a firm generates from its operating activities because it paints the best picture of how well the business is producing cash that will ultimately benefit shareholders.

The cash flows from investing activities section shows the amount of cash firms spent on investments. Investments are usually classified as either capital expenditures--money spent on items such as new equipment or anything else needed to keep the business running--or monetary investments such as the purchase or sale of money market funds.

The cash flows from financing activities section includes any activities involved in transactions with the company's owners or debtors. For example, cash proceeds from new debt, or dividends paid to investors would be found in this section.

Free cash flow represents the amount of excess cash a company generated, which can be used to enrich shareholders or invest in new opportunities for the business without hurting the existing operations; thus, it's considered "free"(Wiley & Sons, 2004, 2005, course 107).

Cash from Operations - Capital Expenditures = Free Cash Flow

Income statement. The most important financial statement for the majority of users is likely to be the income statement, since it reveals the ability of a business to generate a profit. Also, the information listed on the income statement is mostly in relatively current dollars, and so represents a reasonable degree of accuracy.

Balance sheet. The balance sheet is likely to be ranked third, since it does not reveal the results of operations, and some of the numbers listed in it may be based on historical costs, which renders the report less informative.

Statement of cash flows. A possible candidate for most important financial statement is the statement of cash flows, because it focuses solely on changes in cash inflows and outflows.

Bragg, S. (2014, March 15). Which financial statement if the most important?

Wiley & Sons, (2004, 2005). Introductions to Financial Statements.