Question:Please show all details and you can use excel to build some tables. Your goal is to figure out whether starting a microbrewery in Nova…

Question:Please show all details and you can use excel to build some tables.

Your goal is to figure out whether starting a microbrewery in Nova Scotia is a good idea or not. You need to perform net present value analysis. In addition, you need to estimate payback period, discounted payback, internal rate of return and profitability index. If you cannot estimate a certain parameter, indicate why.

The inputs for your analysis are as follows:

  • you will run the business for ten years, and then you close the shop.
  • net sales forecasts are as follows:   

year one  $200,000

year two $1,000,000 

year three $2,000,000

Starting year four, your sales will grow at a rate of 3 percent until year ten, when you close the business. You could grow sales faster if you expanded into other provinces, but provincial governments in Canada impose regulatory hurdles on beer imports from other provinces.

  • costs of goods sold are sixty five percent of sales.
  • selling, general and administrative expenses are 25 percent of sales.
  • initial investment in equipment equals $600,000. Unless you choose to use a CCA formula, you will need to build a CCA schedule for ten years of operations. For simplicity, assume that there are no more capital expenditures and that at the end of year ten, equipment is sold at remaining book value (UCC). CCA rate equals 30 percent.
  • Your federal tax rate is 11 percent. You pay no provincial tax in the first three years of operations. After that, you start paying provincial tax at a rate of 4.5 percent. For simplicity, assume that losses accumulated in the first years cannot be applied to reduce taxable income in later years, ie there are no tax loss carry forwards.
  • Equipment purchase for a microbrewery costs $600,000 (see extract from The Wall Street Journal article on the next page). Half of that amount is funded with a loan that carries interest rate of 7 percent.
  • starting a brewery requires immediate working capital outlay of $10,000. Net working capital is maintained at 5 percent of sales throughout the life of the project.
  • cost of capital equals 20 percent, slightly below returns required by late stage venture capital firms.
  • To facilitate your task, I built income statement for year one (see attachment 2). I need you to build the rest of the income statement and CCA schedule in Excel, and copy/paste them into your deliverable.

Attachment 1 Pro forma income statement for the first year of operations.

net sales                                 $200,000

cost of goods sold                   $130,000

gross profit                              $70,000

overheads                               $50,000

depreciation                            $90,000

operating profit (EBIT)          -$70,000

interest                                    $21,000

pre-tax profit                           -$91,000

tax                                           $0 (no tax is paid on negative earnings)                  

net income                              -$91,000

Note that for net present value analysis, operating cash flow should be estimated based on after-tax operating profit that excludes interest tax shield.

depreciation schedul                year one

book value starting balance  $600,000

depreciation                             $90,000

book value ending balance      $510,000

[1] If you use CCA formula, your payback and discounted payback will be slightly different than if you include depreciation in the income statement.

[2] If you are interested to learn how Canadian provinces impose barriers on beer trade from other provinces, check out www.realbeer.com/library/authors/hughey-r/distribution.php.

[3] Reduced federal income tax rate of eleven percent applies to small business income up to $500,000. The limit was raised from $400,000 as of 2009. See www.cra-arc.gc.ca/tx/bsnss/tpcs/crprtns/rts-eng.html.

[4] New small business tax deduction effectively eliminated the Nova Scotia corporate income tax for the first three taxation years of a new small business after incorporation. The corporation must apply each year to the Nova Scotia Minister of Finance for a Nova Scotia Tax Deduction Eligibility Certificate. Check www.novascotia.ca/finance/en/home/taxation/businesstax/corporateincometax/newsmallbusinesstaxdeduction/default.aspx.

[5] Corporate income tax rate of 4.5 per cent applies up to the Nova Scotia business limit of $400,000 in taxable earnings. This rate is also known as the Small Business Rate and applies to all Canadian-controlled private corporations with limited taxable capital. You may wish to check out www.novascotia.ca/finance/en/home/taxation/businesstax/corporateincometax/default.aspx.

[6] Industry Canada – www.ic.gc.ca – FAQ says that maximum fixed rate on a small business loan equals the lenders’ single family residential mortgage rate plus three percent. Currently, five-seven year mortgages are offered at approximately four percent, so the rate on the loan is set at seven percent.

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more