Business plan financials guide

Assignment Help Finance Basics
Reference no: EM131069016

Important Notes

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

  1. 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.
  2. Develop the following financial sections of your NAB company's Business Plan. Note: Attach the MS Word document to the discussion thread.
    1. Sources and use of funds
    2. Plan assumptions
    3. Break-even analysis

Reference no: EM131069016

Questions Cloud

Computing the yield to maturity : Convenient Stores has a bond issue with 10 years to maturity, $1,000 face value, 8% coupon interest compounded semiannually, that are callable in 5 years at $1050. The bonds currently sell in the market for $1,100. What is the yield to maturity?
Brief description of a current or past love relationship : Write a 3 page paper on love. Each student should include a brief description of a current or past love relationship. This may include a romantic relationship, parental relationship, or friendship. Neither the cover page nor the references page is..
Required return for type of bond : AF Inc. issued a bond with an annual coupon rate of 10% with interest paid annually. The bond matures in 15 years. The par value of the bond is $1,000. If your required return for this type of bond is 15%, what is the price you are willing to pay..
Describe the nature and importance of new materials : Describe the nature and importance of new materials and technologies in the creation of new designs (including sports equipment) in the 1960s. Which designs would be impossible in any but the materials they are made of?
Business plan financials guide : 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 Ex..
The function of purchasing within an organization : The function of purchasing within an organization has many aspects.  One strategic area is the contribution to profit for the company. Summarize the importance of the purchasing functions and how they can contribute to the profitability of a firm...
Find the volume of the tetrahedron : Find the mass of the region R bounded by and Find the volume of the tetrahedron shown below
Are community characteristics related to residents fear : Are demographic characteristics of community residents related to fear of crime and is the source of news and information about crime on the Gold Coast related community resident's fear of crime?
Equipment on the statement of cash flows : How would you classify property, plant, and equipment on the statement of cash flows?

Reviews

Write a Review

Finance Basics Questions & Answers

  Find the bonds price today and six months for now offer the

consider a bond paying a coupon rate of 10 per year semiannually when the market interest rte is why 4 per half-year.

  Discuss the relationship that relative inflation rates

discuss the relationship that relative inflation rates between countries have on the specific exchange rates between

  Which of the following would likely encourage a firm

Which of the following would likely encourage a firm to increase the debt in its capital structure?

  Discuss the primary purpose of an organization

Discuss and explain the differences in functions between the Accounting Department of a firm, its Finance Department and its outside accounting firm.

  Consequently earnings appear lower than normal and this

equity valuations in todays market are arguably too high. many analysts assert that price-toearnings ratios are so

  What is the accrued interest on the bond

The current interest rate on comparable debt is 7 percent, so the bond initially sells for $713. What is the accrued interest on the bond for each of the next five years

  What it the weighted average of capital

What it the weighted average of capital?

  What is net value of payments vs. receipts in today dollars

Carol Thomas will pay out $6000 at the end of the year 2, 8000 at the end of year 3 and receive 10000 at the end of year 4. With an interest rate of 13%, what is the net value of the payments vs. receipts in today's dollars?

  Compute the expected inflation rate for the next 12 months

The real risk-free rate for all 3 years is 2 percent. Using the expectations theory, compute the expected inflation rate for the next 12 months.

  Does this hurt the growth in the economy?

Assuming a company does not have enough excess retained earnings to fund future projects that have positive NPV's, they would have to sell debt or issue new capital. Issuing new capital is often thought of as a negative sign to current stock holders,..

  Classify each of the above accounts as a financing activity

the fair view golf amp country club details the following accounts in its financial statements.abaccounts

  In january 2002 six-month 182-day treasury bills were

in january 2002 six-month 182-day treasury bills were issued at a discount of 1.75 percent. what is the annual

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