Question

In: Finance

JSN Enterprise is evaluating its financing requirements for the coming year. The firm has only been...

JSN Enterprise is evaluating its financing requirements for the coming year. The firm has
only been in business for 1 year, but its CFO predicts that the firm's operating expenses,
current assets, net fixed assets, and current liabilities will remain at their current
proportion of sales. Last year JSN had $14 million in sales with net income of $1.4
million. The firm anticipates that next year's sales will reach $15 million with net income
rising to $2 million. Given its present high rate of growth, the firm retains all its earnings
to help defray the cost of new investments. The firm's balance sheet for the year just
ended is found below:

Balance Sheet
12/31/2001 % of Sales
Currentassets $4,000,000 25%
Netfixedassets 6,000,000 50%
Total $10,000,000
LiabilitiesandOwners'Equity
Accountspayable $4,000,000 25%
Long-termdebt 1,000,000 NA
Totalliabilities $5,000,000
Commonstock 2,000,000 NA
Paid-incapital 1,900,000 NA
Retainedearnings 1,100,000
Commonequity 5,000,000
Total $10,000,000

Estimate JSN’s total financing requirements (i.e., total assets) for 2002 and its net funding
requirements (DFN).

Solutions

Expert Solution

The balance sheet for the year ended 31st December, 2001 of JSN Enterprise is provided below:

Current assets

$40,00,000

Net fixed assets

$60,00,000

Total

$1,00,00,000

Liabilities & Owners' Equity

Accounts payable

$40,00,000

Long term debt

$10,00,000

Total liabilities

$50,00,000

Common stock

$20,00,000

Paid-in capital

$19,00,000

Retained earnings

$11,00,000

Common equity

$50,00,000

Total

$1,00,00,000

NA implies that the figures don’t vary directly with sales and are considered to remain constant for the purpose of forecasting financing requirements for the next year.

Given, Sales for last year = $14,000,000

Net income for last year = $14,00,000

Forecasted sales for next year = $15,000,000

Forecasted net income for next year = $2,000,000

Therefore, next year retained earnings = Last year retained earnings + Net income for the year 2002 = $11,00,000 + $2,000,000 = $31,00,000.

The forecasted balance sheet of the entity for the year of 2002 is as follows:

Balance Sheet

Percentage of sales

2002

Sales

$1,50,00,000

Net income

$20,00,000

Current assets (Sales X 25 %)

25%

$37,50,000

Net fixed assets (Sales X 50 %)

50%

$75,00,000

Total Assets

$1,12,50,000

Liabilities & Owners’ Equity

Accounts payable (Sales X 25 %)

25%

$37,50,000

Long term debt

$10,00,000

Total liabilities

$47,50,000

Common stock

$20,00,000

Paid-in capital

$19,00,000

Retained earnings ($11,00,000 + $2,000,000)

$31,00,000

Common equity

$70,00,000

Total liabilities & Equity

$1,17,50,000

DFN = Total assets – total liabilities and equity = $1,12,50,000 - $1,17,50,000 = -$500,000.


Related Solutions

Captain Kirk of the Starship Enterprise has been told by his superiors that only a chemist...
Captain Kirk of the Starship Enterprise has been told by his superiors that only a chemist can be trusted with the combination of the safe containing the dilithium crystals that power the ship. The combination is the pH of solution A, described below followed by the pH of solution C. The chemist must determine the combination using only the information below (all solutions are at 25C). Solution A is 150.0 mL of a 0.150 M solution of the weak monoprotic...
A firm is evaluating a project that costs RM450m, has a five-year life and has a...
A firm is evaluating a project that costs RM450m, has a five-year life and has a salvage value of RM3m. Assume that depreciation is straight line with zero residual value over the life of the project. Working capital of RM35m is needed initially and the same will be released in the final year. Sales are projected at 555,000 units per year with a selling price of RM505 per unit, variable cost RM315 per unit, and fixed costs are RM1,325,000 per...
Financing Strategies A firm based in Mexico has found that its growth is restricted by the...
Financing Strategies A firm based in Mexico has found that its growth is restricted by the limited liquidity of the Mexican capital market. List the firm’s options for raising money on the global capital market. Discuss the pros and cons of each option, and make a recommendation. How might your recommended options be affected if the Mexican peso depreciates significantly on the foreign exchange markets over the next two years?
A firm with no debt financing has a firm value of $50 million. It has a...
A firm with no debt financing has a firm value of $50 million. It has a corporate marginal tax rate of 35 percent. The firm’s investors are estimated to have marginal tax rates of 22 percent on interest income and a weighted average of 17 percent on stock income. The firm is planning to change its capital structure by issuing $10 million in debt, and repurchasing $10 million of common stock. Based on the information above, answer next 2 questions....
Country Farmlands, Inc. is considering the following potential projects for this coming year, but has only $200,000 for these projects:
Constraints on borrowing.  Country Farmlands, Inc. is considering the following potential projects for this coming year, but has only $200,000 for these projects: Project A: Cost $60,000, NPV $4,000, and IRR 11% Project B: Cost $78,000, NPV $6,000, and IRR 12% Project C: Cost $38,000, NPV $3,000, and IRR 10% Project D: Cost $41,000, NPV $4,000, and IRR 9% Project E: Cost $56,000, NPV $6,000, and IRR 13% Project F: Cost $29,000, NPV $2,000, and IRR 7% What projects should...
John Johnson has been working on Swifty Paints' cash budget for the coming year. Based on...
John Johnson has been working on Swifty Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $45,700; cash collections will be $600,000; and cash disbursements will be $634,000. Swifty Paints desires to maintain a $43,000 minimum cash balance. The company has a 6% open line of credit with its bank, which provides short-term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments...
Because of a recession, the inflation rate expected for the coming year is only 4%.
Problem 4-20Inflation Risk PremiumsBecause of a recession, the inflation rate expected for the coming year is only 4%. However, the inflation rate in Year 2 and thereafter is expected to be constant at some level above 4%. Assume that the real risk-free rate is r* = 2% for all maturities and that there are no maturity premiums. If 3-year Treasury notes yield 2 percentage points more than 1-year notes, what inflation rate is expected after Year 1?%
Luxury Resorts has been evaluating how it might expand its sustainability efforts in its hotels. To...
Luxury Resorts has been evaluating how it might expand its sustainability efforts in its hotels. To evaluate these​ options, management has gathered data for the past year for its laundry costs and housekeeping costs. The costs and occupancy data​ include: Requirement 1. Using the​ high-low method, calculate the cost per guest of laundry per day.​ (The volume should be the number of room​ days, which you will have to calculate for each​ month.) Begin by calculating the number of room...
Kwang Hee Company has been engaged in the process of forecasting its financing needs over the...
Kwang Hee Company has been engaged in the process of forecasting its financing needs over the next quarter and has made the following forecasts of planned cash receipts and disbursements: a) Historical and predicted sales: April RM 80,000 August RM 130,000 May RM 100,000 September RM 120,000 June RM 120,000 October RM 100,000 July RM 130,000 November RM 110,000 b) The collection of the sales receipt are as follows: i. 50% is collected in the month of sales ii. 35%...
1.Javier Pena has always been interested in financing artistic projects.  He has recently been offered two financing...
1.Javier Pena has always been interested in financing artistic projects.  He has recently been offered two financing opportunities in the fashion industry: financing a new line of avant-garde youth fashions designed by Jorge Vera, and financing a line of business attire designed by Paolo Ricci.  Javier has had a lot of past experience with these two designers, and has observed that 20% of Vera’s fashion lines are “hits” and 80% are “misses”.  Furthermore, Ricci’s fashion lines are “hits” 30% of the time, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT