fnce370-assign-2-marked
.pdf
keyboard_arrow_up
School
New York University *
*We aren’t endorsed by this school
Course
8263
Subject
Business
Date
Jan 9, 2024
Type
Pages
28
Uploaded by jupyter83 on coursehero.com
Studocu is not sponsored or endorsed by any college or university
Fnce370 assign 2 marked
Overview of Corporate Finance (Athabasca University)
Studocu is not sponsored or endorsed by any college or university
Fnce370 assign 2 marked
Overview of Corporate Finance (Athabasca University)
Downloaded by Umaima Usman (umaimausman2k@gmail.com)
lOMoARcPSD|3866758
FNCE 370v10: Assignment 2
Assignment 2 is worth 5% of your final mark. Complete and submit Assignment 2 after you complete Lesson 6.
Questio
n
Marks
available
Marks
Awarded
Referenc
e
1
20
14
Lesson 2
2
4
4
Lesson 2
3
10
10
Lesson 3
4
13
13
Lesson 4
5
7
3
Lesson 4
6
10
10
Lesson 4
7
7
5
Lesson 4
8
9
8
Lesson 5
9
9
8
Lesson 5
10
5
3
Lesson 6
11
6
6
Lesson 6
Total
100
84
Note on Decimal Places
When working through numerical problems, use as many decimal places as shown on your financial calculator. Do not round your calculated answers until you have reached the final answer. When you reach your final answer, round as follows, unless
the question specifies otherwise (e.g., see the instructions for pro-forma statements in Question 1).
Percentages: round to two decimal places
Dollars: round to two decimal places
Others: round to four decimal places
FNCE 370v10
1
August 2019
Downloaded by Umaima Usman (umaimausman2k@gmail.com)
lOMoARcPSD|3866758
Questions
Use the following information for Delta Corporation to answer question 1: (20 marks total)
Year
20X1
20X2
Net sales
$1,500,000
$1,656,598
Cost of goods sold
675,000
745,469
Depreciation
270,000
298,188
Interest paid
43,600
44,000
Cash
127,500
140,811
Accounts receivable
450,000
496,980
Inventory
525,000
579,809
Net fixed assets
1,800,000
1,987,918
Accounts payable
375,000
414,150
Notes payable
45,000
50,000
Long-term debt
500,000
500,000
Common stock
1,000,000
1,000,000
Retained earnings
982,500
1,241,368
Tax rate
35%
35%
Dividend payout
30%
30%
1.
Delta has 600,000 common shares outstanding. The firm is projecting a 20% increase in net sales for the coming year (20X3). Delta uses the percentage of sales approach to plan
for its financing needs. In using this approach, the firm assumes that cost of goods sold, all assets (current and fixed), and accounts payable will all remain a constant percentage of sales. Depreciation expense is assumed to be 15% of net fixed assets, while notes payable and long-term debt will remain at the same level as 20X2. The interest rate charged on notes payable and long-term debt is also expected to remain the same. The firm will aim to maintain its dividend payout of 30% for the foreseeable future. a.
Construct the pro-forma Statement of Comprehensive Income and Statement of Financial Position for Delta Corporation for 20X3. Calculate the external financing needed (EFN) for 20X3. Round all your numbers in the pro-forma statements to the
nearest dollar. (4 marks)
Delta Corporation
Pro-forma Statement of Comprehensive Income
20X3
FNCE 370v10
2
August 2019
Downloaded by Umaima Usman (umaimausman2k@gmail.com)
lOMoARcPSD|3866758
Sales
$1987918
Cost of goods sold(COGS)
$894563
Depreciation
$298188
Earnings Before Interest Taxes $612941
Interest Paid $44000
Taxable Income
$691530
Taxes (35%)
$242036
Net Income
$449494
Dividends
$134848
Additions to Retained Earnings $314646
Delta Corporation
Pro-forma Statement of Financial Position 20X3
Assets
Liabilities Current Assets
Current Liabilities
Cash
$168973
Accounts Payable
$496980
Accounts Receivable
$596376
Note Payable
$50000
FNCE 370v10
3
August 2019
Downloaded by Umaima Usman (umaimausman2k@gmail.com)
lOMoARcPSD|3866758
Inventory $695771
Total Current Liabilities
$546980
Total Current Assets
$1461120
Long Term Debt
$500000
Total Liabilities
$1046980
Net Fixed Assets
$2385502
Owners’ Equity
Common Stock
$1000000
Retained Earnings
$1556014
Total Owners’ Equity
$2656014
Total Assets
$3846622
Total Liabilities and Owners’ Equity
$3602994
External Financing
Needed
$243628
The total external financing needed is $243628 for Delta Corporation.
4 marks
b.
Based on its 20X2 information, what is Delta’s capital intensity ratio? Round your answer to four decimal places.
(1 mark)
Capital Intensity Ratio = Total Assets/Sales = 3,250,518/1,656,598 = 1.9350
1 mark
c.
What is Delta’s full capacity sales if it is currently operating at 80% capacity (20X2)? Round your answer to the nearest integer. (1 mark)
Current Sales = 1,656,598 = 80%* full capacity sales
Full capacity sales = 1656598/.80 = 2,070,748
1 mark
FNCE 370v10
4
August 2019
Downloaded by Umaima Usman (umaimausman2k@gmail.com)
lOMoARcPSD|3866758
d.
Recalculate the firm’s external financing needed (EFN) for 20X3 if Delta is only operating at 80% capacity. Assume that if the 20X3 net sales is lower than full capacity sales, then the net fixed assets in 20X3 will be the same as the net fixed assets in 20X2 (i.e., assume that the firm will purchase just enough fixed assets to cover depreciation expense for 20X3). Interpret this EFN number. (5 marks)
Delta Corporation
Pro-forma Statement of Comprehensive Income
20X3
Sales
$1656598
Cost of goods sold(COGS)
$745469
Depreciation
$357825
Earnings Before Interest Taxes $733530
Interest Paid $44000
Taxable Income
$568941
Taxes (35%)
$199129
Net Income
$369812
Dividends
$110944
Additions to Retained Earnings $258868
Delta Corporation
Pro-forma Statement of Financial Position 20X3
Assets
Liabilities Current Assets
Current Liabilities
Cash
$140811
Accounts Payable
$414150
FNCE 370v10
5
August 2019
Downloaded by Umaima Usman (umaimausman2k@gmail.com)
lOMoARcPSD|3866758
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Paraphrase this one. Analyze and elaborate in 120 words.
Time series analysis is used for non-stationary data—things that are constantly fluctuating over time or are affected by time. Industries like finance, retail, and economics frequently use time series analysis because currency and sales are always changing. Stock market analysis is an excellent example of time series analysis in action, especially with automated trading algorithms. Likewise, time series analysis is ideal for forecasting weather changes, helping meteorologists predict everything from tomorrow’s weather report to future years of climate change. Examples of time series analysis in action include:
Weather data
Rainfall measurements
Temperature readings
Heart rate monitoring (EKG)
Brain monitoring (EEG)
Quarterly sales
Stock prices
Automated stock trading
Industry forecasts
Interest rates
arrow_forward
Answer the following questions. Make sure to number your answers when you upload your response.
Suppose Alphonso’s town raised the price of bus tickets to $2.50 per trip (while the price of burgers stayed at $3.50 and his budget remained $11.50 per week.) Draw Alphonso’s new budget constraint. What happens to the opportunity cost of bus tickets?
Suppose Alphonso’s town raises the price of bus tickets from $2.50 to $5 and the price of burgers rises from $3.50 to $7. Why is the opportunity cost of bus tickets unchanged? Suppose Alphonso’s weekly spending money increases from $11.50 to $23. How is his budget constraint affected from all three changes? Explain.
Use this information to answer the following 4 questions: Marie has a weekly budget of $24, which she likes to spend on magazines and pies.
If the price of a magazine is $4 each, what is the maximum number of magazines she could buy in a week?
If the price of a pie is $12, what is the maximum number of pies she could buy in a…
arrow_forward
Following paragraph is extracted from (Kumar, Lall & Mane, 2017) research paper. Read the paragraph thoroughly and answer the following questions. (400 to 600 words)
State the research problem of the given study (Describe the problem in your own words)
Justify whether the given problem fulfills the criteria of a good research problem or not.
How this research contributes to the existing literature? Justify.
Formulate the objectives and research question(s), accordingly.
Today, mobile banking services along with Internet banking services have fundamentally changed the ways and methods of doing banking operations by its customers and banks have also used these technology-based service delivery channels not only as a new way to increase customer satisfaction, but also as a strategy to reduce costs and increase profitability. Banks have laid their emphasis on the implementation on mobile banking services because it has helped them to sharpen their focus on reducing costs, enabled…
arrow_forward
Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set.
Use the the excel spreadsheet image and show constraints.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Related Questions
- Paraphrase this one. Analyze and elaborate in 120 words. Time series analysis is used for non-stationary data—things that are constantly fluctuating over time or are affected by time. Industries like finance, retail, and economics frequently use time series analysis because currency and sales are always changing. Stock market analysis is an excellent example of time series analysis in action, especially with automated trading algorithms. Likewise, time series analysis is ideal for forecasting weather changes, helping meteorologists predict everything from tomorrow’s weather report to future years of climate change. Examples of time series analysis in action include: Weather data Rainfall measurements Temperature readings Heart rate monitoring (EKG) Brain monitoring (EEG) Quarterly sales Stock prices Automated stock trading Industry forecasts Interest ratesarrow_forwardAnswer the following questions. Make sure to number your answers when you upload your response. Suppose Alphonso’s town raised the price of bus tickets to $2.50 per trip (while the price of burgers stayed at $3.50 and his budget remained $11.50 per week.) Draw Alphonso’s new budget constraint. What happens to the opportunity cost of bus tickets? Suppose Alphonso’s town raises the price of bus tickets from $2.50 to $5 and the price of burgers rises from $3.50 to $7. Why is the opportunity cost of bus tickets unchanged? Suppose Alphonso’s weekly spending money increases from $11.50 to $23. How is his budget constraint affected from all three changes? Explain. Use this information to answer the following 4 questions: Marie has a weekly budget of $24, which she likes to spend on magazines and pies. If the price of a magazine is $4 each, what is the maximum number of magazines she could buy in a week? If the price of a pie is $12, what is the maximum number of pies she could buy in a…arrow_forwardFollowing paragraph is extracted from (Kumar, Lall & Mane, 2017) research paper. Read the paragraph thoroughly and answer the following questions. (400 to 600 words) State the research problem of the given study (Describe the problem in your own words) Justify whether the given problem fulfills the criteria of a good research problem or not. How this research contributes to the existing literature? Justify. Formulate the objectives and research question(s), accordingly. Today, mobile banking services along with Internet banking services have fundamentally changed the ways and methods of doing banking operations by its customers and banks have also used these technology-based service delivery channels not only as a new way to increase customer satisfaction, but also as a strategy to reduce costs and increase profitability. Banks have laid their emphasis on the implementation on mobile banking services because it has helped them to sharpen their focus on reducing costs, enabled…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,