At last year’s end, total assets for Roberts Inc. were $1.2 million and accounts payable were $375,000. Sales, which last year were $2.5 million, are expected to increase by 25 percent this year. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Robert Inc. typically uses no current liabilities other than accounts payable. Common stock amounted to $425,000 last year, and retained earnings were $295,000. Roberts Inc. plans to sell new common stock in the amount of $75,000. The Firm’s profit margin on sales is 6 percent; and 60 percent of earnings will be retained. Set up Roberts Inc.’s last year balance sheet, to the extent possible, based on the information provided in this problem. Based on the balance sheet setup in Part a

Financial Accounting
15th Edition
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter17: Financial Statement Analysis
Section: Chapter Questions
Problem 20E: Five measures of solvency or profitability The balance sheet for Garcon Inc. at the end of the...
icon
Related questions
Question

At last year’s end, total assets for Roberts Inc. were $1.2 million and accounts payable were $375,000. Sales, which last year were $2.5 million, are expected to increase by 25 percent this year. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Robert Inc. typically uses no current liabilities other than accounts payable. Common stock amounted to $425,000 last year, and retained earnings were $295,000. Roberts Inc. plans to sell new common stock in the amount of $75,000. The Firm’s profit margin on sales is 6 percent; and 60 percent of earnings will be retained.

  1. Set up Roberts Inc.’s last year balance sheet, to the extent possible, based on the information provided in this problem.
  2. Based on the balance sheet setup in Part a above, determine how much was Roberts Inc.’s long-term debt last year?
  3. Perform financial forecasting using percent of sales method (i.e., constant ratio method; do not use the AFN Equation) to determine how much is Robert Inc.’s additional funds needed (AFN) for this year.
  4. Based on your answer to Part c above, determine how much new long-term debt financing will Roberts Inc. need to raise in this year?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Forecasting Financial Statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning