Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

Use historical financial statements for the years 1993, 1994, and 1995 to develop pro forma financial statements for the company (both an income statement and a balance sheet). As outlined in the case, your firm projects a 20% increase in sales for 1996 and 1997.

For the ended in 1995, Tire City had sales of $23,505,000.00. Net income for that period was $1,190,000.00. During the previous 3 years, sales had grown at a compound annual rate in excess of 20%.

In 1991, Tire City had borrowed from Mid-Bank to build a warehouse. This loan was being repaid in equal annual installments of $125,000.00. At the end of 1995, the balance due on the loan was $875,000.00. Also, in 1991 Tire City established a line of credit at Mid Bank. The company had not yet borrowed any money under this credit arrangement.

Tire City decided to expand its warehouse facilities. During the next 18 months, Tire City planned to invest $2,400,000.00 in the expansion, $2,000,000.00 of which would be spent during 1996 (no other capital expenditures would be spent in 1997 and 1997). The expansion project will be completed in 1997.

Therefore no depreciation could be deducted in 1996. However, Tire City was told they could depreciate the warehouse by 5% of the total cost in 1997. Total depreciation expense on its other assets in 1996 and 1997 would be the same as it was in 1995.

During the construction of the warehouse, inventories would drop to a level of $1,625,000.00 by the end of 1996, much lower than the $2,190,000.00 shown at the end of 1995. However, this temporary drop would only last until the end of 1997 where inventory would raise back to the same proportional relationship to sales that it had in 1995.

Cash balances would be maintained at a level of 3% of sale during the next 2 years. Although the federal marginal corporate tax rate was 35%, the average tax rate on Tire City pre-taxed income had typically been higher than this due to misc. local taxes. Future taxation was expected to continue in future at rates consistent with the most recent past experiences. Dividend payouts will remain the same in the foreseeable future.

The construction loan from Mid-Bank will be drawn in two separate parts. One in 1996 and one in 1997. The loan would be repaid in 4 equal annual installments. The first installment payment would take place one year after construction of the warehouse was completed (1998). The interest rate is set at 10% per year.

In preparation for this loan, we are creating a pro forma and projecting a 20% increase in sales each year in 1996 and 1997 from $23,505,000 to $28,206,000 and 33,847,000.

For years ending 12/31

1993

1994

1995

1996

1997







INCOME STATEMENT












Net sales

$16,230

$20,355

$23,505

28,206

33,847

Cost of sales

9,430

11,898

13,612

16,224

19,601

Gross profit

6,800

8,457

9,893

11,872

14,246

Selling, general, and administrative expenses

5,195

6,352

7,471

8,965

10,758

Depreciation

160

180

213

256

307

Net interest expense

119

106

94

113

135

Pre-tax income

1,326

1,819

2,115

2,538

3,046

Income taxes

546

822

925

1,110

1,332

Net income

$780

$997

$1,190

1,428

1,714







Dividends

$155

$200

$240

288

346







BALANCE SHEET






Assets






Cash

$508

$609

$706



Accounts receivable

2,545

3,095

3,652



Inventories

1,630

1,838

2,190



Total current assets

4,683

5,542

6,548









Gross plant & equipment

3,232

3,795

4,163



Accumulated depreciation

1,335

1,515

1,728



Net plant & equipment

1,897

2,280

2,435









Total assets

$6,580

$7,822

$8,983









LIABILITIES












Current maturities of

$125

$125

$125



long-term debt



Accounts payable

1,042

1,325

1,440



Accrued expenses

1,145

1,432

1,653



Total current liabilities

2,312

2,882

3,218









Long-term debt

1,000

875

750









Common stock

1,135

1,135

1,135



Retained earnings

2,133

2,930

3,880



Total shareholders' equity

3,268

4,065

5,015









Total liabilities

$6,580

$7,822

$8,983



 

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92878421

Have any Question?


Related Questions in Financial Management

In a long essay of 1500 words you must reflect on the

In a long essay of 1,500 words, you must reflect on the Palliser Furniture cases. Please answer the following three questions: Palliser Furniture Ltd. Palliser Furniture Ltd.: The China Question Questions : What were Pal ...

Part iplease explain your opinion in about 150 words for

PART I Please explain your opinion in about 150 words for each question below: Would you go to "battle" without a contingency plan? Can you decide on your leaving point without forming your BATNA first? Would you "Share/ ...

Please post the answer directly i will buyben wants to

Please post the answer Directly. I will buy. Ben wants to design a risky portfolio from two funds, Momentum Fund and Value Fund. Momentum Fund has an expected return of 35% and a standard deviation of return of 40%. Valu ...

Assignment - capital asset pricing model and required

Assignment - Capital asset pricing model and required returns 1. Select two stocks that have prices available for the last ten years. (You may find it more interesting if you select one stock that is relatively risky and ...

Discussion question find an example of a document that

Discussion Question : Find an example of a document that misuses graphics. This can be a document that you have received (please blot out any sensitive information and names) or a document that you find on the Internet. ...

Exerciseas the executive of a bank or thrift institution

Exercise As the executive of a bank or thrift institution you are faced with an intense seasonal demand for loans. Assuming that your loanable funds are inadequate to take care of the demand, how might your Reserve Bank ...

Case analysis questions1 explain in 175 words what makes a

Case Analysis Questions 1. Explain in 175 words what makes a company a “multinational corporation”. 2. Complete the chart in a total of 350 words using 3 to 5 examples of multinational corporations. 3. Reading through th ...

Topic dash dietthere are many different diets weight loss

Topic: DASH DIET There are many different diets, weight loss treatments, and medications that proclaim to be the panacea for weight loss. For this discussion forum, you will be researching a diet or treatment approach fo ...

This assignment investigates the financial needs of your

This assignment investigates the financial needs of your business venture from Assignment. Write a three to four (3-4) page paper in which you: Outline the financial start-up needs for this business. Consider such items ...

Part 1 conduct internet research sources must be documented

Part 1. Conduct Internet research, (sources must be documented using MLA format), and write a brief analysis of the current status of the U.S. economy. Include current values and trends for at least three of the followin ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As