After Tax Analysis for Business Expansion

Group Project Option 2: After-Tax Analysis for Business Expansion


Don't use plagiarized sources. Get Your Custom Essay on
After Tax Analysis for Business Expansion
Just from $13/Page
Order Essay

Charles was always a hands-on type of person. Within a couple of years of graduating from college, he started his own business. After some 20 years, it has grown significantly. He owns and operates Pro-Fence, Inc. in the Metroplex, specializing in custom-made metal and stone fencing for commercial and residential sites. For some time, Charles has thought he should expand into a new geographic region, with the target area being another large metropolitan area about 500 miles north, called Victoria.

Pro-Fence is privately owned by Charles; therefore, the question of how to finance such an expansion has been, and still is, the major challenge. Debt financing would not be a problem in that the Victoria Bank has already offered a loan of up to $2 million. Taking capital from the retained earnings of Pro-Fence is a second possibility, but taking too much will jeopardize the current business, especially if the expansion were not an economic success and Pro-Fence were stuck with a large loan to repay.

This is where you come in as a long-time friend of Charles. He knows you are quite economically oriented and that you understand the rudiments of debt and equity financing and economic analysis. He wants you to advise him on the balance between using Pro-Fence funds and borrowed funds. You have agreed to help him, as much as you can.


Charles has collected some information that he shares with you. Between his accountant and a small market survey of the business opportunities in Victoria, the following generalized estimates seem reasonable:

· Initial capital investment = $1.5 million

· Annual gross income = $700,000

· Annual operating expenses = $100,000

· Effective income tax rate for Pro-Fence = 35%

· Five-year MACRS depreciation for all $1.5 million investment


The terms of the Victoria Bank loan would be 6% per year simple interest based on the initial loan principal. Repayment would be in five equal payments of interest and principal. Charles comments that this is not the best loan arrangement he hopes to get, but it is a good worst-case scenario upon which to base the debt portion of the analysis. A range of D-E mixes should be analyzed. Between Charles and yourself, you have developed the following viable options:

Debt Equity table
Debt   Equity
Percentage Loan Amount, $   Percentage Investment Amount, $
  0     100 1,500,000
50    750,000   50    750,000
70 1,050,000   30    450,000
90 1,350,000   10    150,000

Case Study Exercises

1. For each funding option, perform a spreadsheet analysis that shows the total CFAT and its present worth over a 6-year period, the time it will take to realize the full advantage of MACRS depreciation. An after-tax return of 10% is expected. Which funding option is best for Pro-Fence? (Hint:For the spreadsheet, sample column headings are: year, GI − OE, loan interest, loan principal, equity investment, depreciation rate, depreciation, book value, TI, taxes, and CFAT.)

2. Observe the changes in the total 6-year CFAT as the D-E percentages change. If the time value of money is neglected, what is the constant amount by which this sum changes for every 10% increase in equity funding?

3. Charles noticed that the CFAT total and PW values go in opposite directions as the equity percentage increases. He wants to know why this phenomenon occurs. How should you explain this to Charles?

4. After deciding on the 50-50 split of debt and equity financing, Charles wants to know what additional bottom-line contributions to the economic worth of the company may be added by the new Victoria site. What are the best estimates at this time?

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 817 953 0426

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

Order your essay today and save 15% with the discount code NERDY