Course Project 2

Course Project2 Due on

To complete Course Project 2, you will need to estimate future cash flows for a firm and then
apply discounted cash flow analysis to estimate the value of a firm. You will then need to
decide if you would sell the firm at a specific price.

This project must be submitted as an Excel file. You have until midnight on the due date to
turn in the project by Blackboard. Any late project will be accepted at my discretion
depending on the degree of lateness. Your work must be submitted as a readable Excel file.

The project is worth a total of 25 points. To receive all 25 points, you should make sure to fully
complete the Excel file while following all directions. You should only hard code (aka type
directly) into the grey cells. All of the other cells (blue, green, orange) should only include
formulas and cell references. Failure to follow this will result in a significant or total loss of

Project Problem

1. Organic Micros was established 8 years ago by Mary Mendoza. The firm reported EBIT
this year of $80,000. Mary typically reports about $2,000 in personal expenses through
the firm each year. She also pays herself a salary of $60,000 despite the market rate for
such a position being closer to $30,000.

2. The firm currently reports $10,000 in depreciation expenses every year.
3. The firm will need $25,000 of inventory replaced in year 1 and will also require the

replacement of equipment during year 4 in an amount totaling $50,000.
4. The firm currently has outstanding debt of $400,000. The firm has been historically

financed in a way that 30% of funds are a result of debt financing. The cost of this debt
financing is estimated to be 12% while the cost of equity financing is estimated at 22%.

5. Mary originally invested $120,000 of her own funds in the firm which establishes a cost
basis for the firm of $120,000. Mary typically falls in a tax bracket that results in a total
tax rate of 40%.

6. Based on the firm’s maturity and the state of the industry, it is estimated the EBIT will
increase by 9% each year for the next 5 years. Beyond this time frame, a reasonable
estimate of growth is neither possible nor relevant.

Point Breakdown Point Deductions

Free Cash Flows 10 pts
NPV 6 pts
Net proceeds 6 pts
Sell decisions 2 pts
Name 1 pt

Missing formula/reference -1 (per)
No formulas/references -25
Wrong calculation -2 (per)
Wrong sell decision -1 (per)
No name -1
No Excel file -25

Late (if accepted) -5

Place your order
(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:
The price is based on these factors:
Academic level
Number of pages
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
error: Content is protected !!
Open chat
You can contact our live agent via WhatsApp! Via + 1 929 473-0077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code GURUH