Company is planning its operations for next year, and as its CFO, you will need to forecast the company’s additional funds needed (AFN) based on the following data. Dollars are in millions. Last year’s sales = $364                           Last year’s accounts payable = $58 Sales growth rate = 30%                       Last year’s notes payable = $50 Last year’s total assets = $548                Last year’s accruals = $30 Last year’s profit margin = 5.32%            Target payout ratio = 60% Your company is operating at full capacity. Based on the AFN formula and the Percentage of Sales method, what is the AFN for the coming year?  Round your answer to two decimal places of dollar, but ignore dollar and millions, e.g., xxx.xx. (Hint: Use the AFN General Formula in Financial Forecasting.)

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 10P
icon
Related questions
Question

Company is planning its operations for next year, and as its CFO, you will need to forecast the company’s additional funds needed (AFN) based on the following data. Dollars are in millions.

Last year’s sales = $364                           Last year’s accounts payable = $58
Sales growth rate = 30%                       Last year’s notes payable = $50
Last year’s total assets = $548                Last year’s accruals = $30
Last year’s profit margin = 5.32%            Target payout ratio = 60%

Your company is operating at full capacity. Based on the AFN formula and the Percentage of Sales method, what is the AFN for the coming year?  Round your answer to two decimal places of dollar, but ignore dollar and millions, e.g., xxx.xx. (Hint: Use the AFN General Formula in Financial Forecasting.)

Answer: 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 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, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage