Uncategorized

Calculations using EFN

Please use the financials for Dilworth Corp. to work the following:
1. Estimate the EFN for 2021, assuming a sales growth rate of 10%. Make sure to use ONLY the “Direct Method”, NOT the “Auto Calc” method.
2. Assume that the company has excess capacity as of the end of 2020, with a capacity utilization of 90%. Re-estimate EFN for 2021 (sales growth rate of
10%) given this excess capacity.
Note: Assume that the dividend payout ratio remains the same for 2021. Also, note that the numbers are all in thousands of dollars. You must use Excel to do
your work!
1. Estimate the EFN for 2021, assuming a sales growth rate of 10%. Make sure to use ONLY the “Direct Method”, NOT the “Auto Calc” method.
2. Assume that the company has excess capacity as of the end of 2020, with a capacity utilization of 90%. Re-estimate EFN for 2021 (sales growth rate of
10%) given this excess capacity.
Note: Assume that the dividend payout ratio remains the same for 2021. Also, note that the numbers are all in thousands of dollars. You must use Excel to do
your work!
Coursework related to EFN has been included. Use direct method and excess capacity. Do NOT use the auto calc method with highlighted interest. Use
formulas

Essay Mill

Share
Published by
Essay Mill

Recent Posts

Childbirth

For this short paper activity, you will learn about the three delays model, which explains…

2 months ago

Literature

 This is a short essay that compares a common theme or motif in two works…

2 months ago

Hospital Adult Medical Surgical Collaboration Area

Topic : Hospital adult medical surgical collaboration area a. Current Menu Analysis (5 points/5%) Analyze…

2 months ago

Predictive and Qualitative Analysis Report

As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us,…

2 months ago

Business Intelligence

Read the business intelligence articles: Getting to Know the World of Business Intelligence Business intelligence…

2 months ago

Alcohol Abuse

The behaviors of a population can put it at risk for specific health conditions. Studies…

2 months ago