Explain how do you plan to use the funds

Assignment Help Finance Basics
Reference no: EM132234268

Assignment: Make sure that you pay attention to all the directions

This discussion is worth 80 points and it is part of your Course Project. You will earn 70 points for the PIN (written section+Excel - only if you submit both) and 10 points for each substantive comment.

Before you get started on this exercise, you will need the textbook (Chapter 16- The Financials), the Business Plan Financials Guide and Excel document, and NAB Company Portfolio.

This Assignment has two sections: The Excel document and the written portion of the financials (sources and use of funds, plan assumption, break-even analysis) as described below.

Section I: The Business Plan financials (Excel document)- complete this first

Using your NAB Company Portfolio and the first year of your business plan for the company, you will complete all the worksheets in the entire Excel document in order, so that you can complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials spreadsheet.

To help you address this section:

Video explaining how to complete the Excel worksheet: Final BUS599- Week 7 Discussion- part I- how to complete the Excel document

Notes: • The setup and marketing worksheet should already be completed from assignment 2.

• Use the instructions provided in the Business Plan Financials Guide to help you complete this document, as well as the NAB Portfolio (pages 4-8).

To submit: Attach the completed Excel worksheet to the discussion thread (click on the Add Content button under the Post button to access the attachment option when you are ready to submit, attach your document and then click submit)

Section II: Financial section of the business plan (type in a Word document and paste in the discussion window). You will have 3 headings as outlined below:

To help you address this section:

Video explaining how to complete the written portion of your Financials: BUS599 - Week 7 Discussion- Section 2-sources and use of funds, assumptions, brkevn

1. Sources and use of funds

• Outline the funds you have currently (see portfolio pages 4 and 8) and the ones you intend to raise (you need to raise funds per the portfolio page 4)

• Explain how do you plan to use the funds (a clear plan on how you will use the money)

Notes: Before addressing this section please review:

- Sources and Use of Funds section on page 312 of your textbook

- Sample plan on page 325 for an idea on how to address this section.

2. Plan assumptions

The Financial plan must be based on decisions and facts. Investors want to know if this plan is realistic. In this section you will outline your plan assumptions.

Notes: Before addressing this section please review:

• The setup and assumptions sheet in your Excel document.

• Sample plan in your textbook page 326

• Assumption sheet in your textbook page 313.

• Article about the 5 key assumptions of your business plan: Questioning Key Assumptions in Your Business Plan - Why You Need to Ask the Tough Questions (By Amanda Mccormick)

The break-even point is where you make enough money in revenue to pay your expenses but you do not make money nor you do not lose money. In this section, you need to determine what this break-even point is.

Notes: Before addressing this section please review:

- Page 314 in the textbook about break-even analysis

- The BrkEvn (Break-Even) worksheet in your Excel document. You would have calculated this there.

Final notes:

• You will use the Excel document in Assignment 3 and 5.

• You will use the written portion of your Financials in Assignment 5.

Reference no: EM132234268

Corporate social responsibility and its importance

Analyze corporate social responsibility and its importance in new business ventures. How do you demonstrate your commitment to corporate social responsibility in your busine

Information and conclusion about the questions

What exchange rate system did Argentina adopt before 2002? Why? What factors contributed to the Argentina currency crisis? Write more information and conclusion about the que

What is the required return for jjm

Jersey Jewel Mining has a beta coefficient of 1.2. Currently the risk-free rate is 5 percent and the anticipated return on the market is 11 percent. JJM pays a $4.50 dividen

Benefits are based on career-average earnings

1) Defined-benefit plans are favorable to employees for which of the following reasons a) Key employees like to invest the funds that accumulate in their individual accounts.

Advantage of to protect portfolio value

Assume that you anticipate the stock in your portfolio will experience a significant decline within the next three months. Research and describe two option strategies that y

Where is the optimal capital structure

How do the cost of debt, the cost of equity, and the weighted average cost of capital (WACC) behave as the firm’s financial leverage increases from zero? Where is the optimal

Incremental cash flow related to working capital

To estimate the increase in working capital, analysts estimate the ratio of cash and cash-equivalents to revenue to be 0.03 and the ratios of receivables, inventories, and p

What is the bond refunding npv

The new bonds would be issued 1 month before the old bonds are called, with proceeds being invested in short term government securities returning 6% annually during the inte


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd