Question: Complete Problems 17-7 (one year pro forma statement) and 17-8 (total liabilities estimation and forecast of long-term debt financing need) in your course text. In

Complete Problems 17-7 (one year pro forma statement) and 17-8 (total liabilities estimation and forecast of long-term debt financing need) in your course text. In addition, provide two or more suggestions on what Ambrose Inc. could do to reduce the forecasted debt financing (the managerial part of financing). Be sure to provide rationales as to why your suggestions will be effective in reducing the forecasted debt financing need.

17-7: Pro Forma Income Statement - Roberts Inc. (in millions of dollars) 2015 (last year) Change Forecast Formula

1, Sales $3,000.00

2. Operating costs excluding depreciation $2,450.00 3. EBITDA $550.00 4. Depreciation $250.00 5. EBIT $300.00 6. Interest $125.00 7. EBT $175.00 8. Taxes (40%) $70.00 year-end sales are expected to be 10% higher than the 3 billion in sales generated last year

year-end operation costs, excluding depreciation, are expected to equal 80% of year-end sales

Depreciation is expected to increase at the same rate as sales

interest costs are expected to remain unchanged

the tax rate is expected to remain at 40%

on the basis of that information what will be the forecast for robert's year-end net income

I need the calculations for 8 areas and the year-end net income

----

Problem 2

At year-end 2015

Total Assets: $1.2 million

Accounts payable $375,000

Sales $2.5 million (2015)

--- increase sales by 25% in 2016

assets and account payable are proportional to sales and grow at same rate

no current liabilities other than account payable

Common stock amounted to $245,000 in 2015

retained earnings $295,000

Plans to sell new common stock in amount of $75,000

Profit Margin on sales 6%

60% of earnings will be retained

What were total liabilities in 2015?

How much new long-term debt financing will be needed in 2016? (hint:AFN-New Stock = New Long-term debt)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

For this Assignment, complete Problems 17-7 (one year pro forma statement) and 17-8 (total liabilities estimation and forecast of long-term debt financing need) in your course text. In addition,...

In your accounting course, you learned about the income statement that provides a record of what led to net income for the year. Just as you might develop a forecast of the future year's budget,...

For this Assignment, complete Problems 17-7 (one year pro forma statement) and 17-8 (total liabilities estimation and forecast of long-term debt financing need) in your course text. In addition,...

In your accounting course, you learned about the income statement that provides a record of what led to net income for the year. Just as you might develop a forecast of the future year's budget,...

See attached problem set questions 17-7 and 17-8 Application: Estimating Financing Needs In your accounting course, you learned about the income statement that provides a record of what led to net...

Application Estimating Financing Needs In your accounting course, you learned about the income statement that provides a record of what led to net income for the year. Just as you might develop a...

Estimating Financing Needs In your accounting course, you learned about the income statement that provides a record of what led to net income for the year. Just as you might develop a forecast of the...

Estimating Financial Needs Application 6: Estimating Financing Needs In your accounting course, you learned about the income statement that provides a record of what led to net income for the year....

List any audit procedures not involving ACL in the audit of inventory that you believe should be performed.

Dennis is the first to admit he is paid more than he deserves for the level of work he performs. Therefore, he knowingly over withholds on both his federal and California state taxes. Every year...

What is the most common funding sequence entrepreneurs typically use for new ventures? Bootstrapping to debt to equity Debt to bootstrapping to equity Debt to equity to bootstrapping Equity to...

There are three types of responsibility centers: cost, segment, and investment. There are three types of responsibility centers: cost, segment, and investment. True False

The bookkeeper for Careless Company accidentally pressed the wrong computer key and erased the amount of Retained Earnings. You have been asked to analyze the following data and provide some key...

As an auditor, you have discovered the following problems with the accounting system control procedures of Jefferson Retailers. For each of the following occurrences, tell which of the five internal...

Which of the following is not applicable to the internal audit function? Deter or catch employee fraud. Issue an opinion for investors regarding the reliability of the financial statements. Be guided...