Description
follow the file.
Unformatted Attachment Preview
FINANCE 304
COMPUTER ASSIGNMENT
INSTRUCTIONS: You will be allowed to do this project on any spreadsheet software packages. The
instructor currently has access to the following packages: (1) Excel (2) Quattro Pro. The use of any other
software may be approved by the instructor.
PROJECT
Doredo Steel Company is a wholesale steel distributor which purchase steel in carload lots and
sells to several thousand steel users. The nature of the steel business requires that the company maintain
large inventories to take care of customer requirements in the event of mill strikes or other delays.
In examining records from 1992 to 2015, the company found consistent relationships among the
following accounts as a percent of sales:
Current assets
Net fixed assets
Accounts payable
Other current liab.
Profit margin
20%
60% if Sales < $53 million
70%, otherwise.
8%
6%
12%
The company’s sales for 2016 were $40 million. The company expects to grow by $6 million per
year over the next 5 years. The company wants to project its financial requirements for each of the next 5
years, assuming that the projected sales levels are achieved. Assume further that the company pays out 25
percent of earnings as dividends.
Construct pro forma balance sheets for the end of each of the next 5 years (from 2017 to 2021),
assuming that 20 percent by issuing long-term debt, and 80 percent by selling new common stock.
NOTE: You will be expected to unload your file to the Canvas by 11:00 am on March 22.
NAME ____________________
____________________________________________________________________________________
Doredo Steel Company
PRO FORMA Balance Sheet
For the Period of 2017-2021
(Thousands of Dollars)
____________________________________________________________________________________
YEAR
2016
2017
2018
2019
2020
2021
Sales
40,000
$0.0
+N5+
+N6+
+N7+
$0.0
Current A
10,000
$0.0
+P8+
+P9+
+P10+
$0.0
Fixed A
26,000
Total
36,000
Acct Payable
5,000
Other cur L
2,500
L/t debt
9,000
Common St
14,000
Retained
5,500
Tot. L&E
36,000
*Interests $120,000 Constant
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
There you go..Let me know if you need anything and goodbye
Name:
YEAR
SALES
CURRENT Assets
FIXED Assets
TOTAL
Acct Payable
Other cu...
Completion Status:
100%
Review
Review
Anonymous
Super useful! Studypool never disappoints.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Writing Assignment: Researching Innovation, economics homework help
As a teen consumer, you are surrounded by products that have literally "changed the world" in the last five years. Wh ...
Writing Assignment: Researching Innovation, economics homework help
As a teen consumer, you are surrounded by products that have literally "changed the world" in the last five years. Whether you have an MP3 player, video game, or your own personal computer, you more than likely have access to many time-saving, innovative products. Choose one of the companies that have produced an innovative product that you use often. Then in a writing assignment that is at least two well-developed paragraphs in length, answer the following questions.1.Who was the person or team who created the company?2.As the entrepreneurs of the company, how did they combine the factors of production to make life easier or more convenient for Americans?3.Identify at least three benefits of purchasing and using this product.4.Can you think of any drawbacks or problems the company has faced or may face in the future?
Economic college
Assignment DetailsAs an employee of a company that is considering investing in a foreign economy, you have been asked to r ...
Economic college
Assignment DetailsAs an employee of a company that is considering investing in a foreign economy, you have been asked to research a country and make a presentation to your colleagues about an area of economic concern in the country. Select a country in Africa, Asia, or Latin America to research. Select 1 of the following economic concerns to research: Gross Domestic Product (GDP) Unemployment Inflation Quantities of specific goods and services Exports and importsResearch data sets for the one economic concern within the country that you have chosen. Prepare 1 presentation consisting of 10-12 Power Point slides and answer the following questions: What are 2–3 relationships between the economic concern you selected and that specific country's economy? Support your discussion of the trends with statistical evidence. Use graphs and/or data tables of the variables you chose in the discussion.What trends do you see in the data sets? Please explain. Cite all of your sources and include a reference list Your research and slides will form the basis for your Unit 4 IP paper, so please be sure to be careful and thorough in your research. Present your information, with appropriate pictures/graphics, in a PowerPoint presentation. The main topics or bullet points should appear on the slides with supporting visuals, while the Speaker Notes area (the box located at the bottom of each slide which allows you to type in notes) should be used to go into more depth regarding these main topics. Make sure the notes include information from the sources you have discovered in your research. This is very important element of your assignments as it will provide both you and your audience with supporting explanations that the bullet posts simply can’t convey.Your presentation should consist of a minimum of 12 slides of content, and the following: a title slide, an introductory slide, a conclusions slide, and a references slide. Use the following resources for assistance:Access the template provided, or create your own slideshow following the requirements listed above.Refer to the Microsoft Office website for assistance with PowerPoint: https://support.office.com/en-us/article/Basic-tasks-for-creating-a-PowerPoint-presentation-efbbc1cd-c5f1-4264-b48e-c8a7b0334e36. The Smarthinking resource is also available to assist in the basics of the PowerPoint tool.Use at least two sources when researching information to support your argument. Remember to use credible, current sources to support your presentation. Use APA reference and citation format for the sources that you use. Place citations on the relevant slides with one or two slides at the end for your reference list.
ECO550 SU Analysis of Risk Uncertainty & Managing Incentives Case Study
CASE STUDY 2: Cases Analysis of Risk, Uncertainty and Managing Incentives
Select a company of your choice, any company but ...
ECO550 SU Analysis of Risk Uncertainty & Managing Incentives Case Study
CASE STUDY 2: Cases Analysis of Risk, Uncertainty and Managing Incentives
Select a company of your choice, any company but Southwest Airlines, and write a six to eight (6-8) page paper in which you:
Evaluate a company’s recent (with in the last year) actions dealing with risk and uncertainty.
Offer advice for improving risk management.
For the company you selected examine an adverse selection problem and recommend how it should minimize its negative impact on transactions.
For the company you selected determine the ways in which it is dealing with the moral hazard problem and suggest best practices used in the industry to deal with it.
For the company you selected identify a principal-agent problem and evaluate the tools it uses to align incentives and improve profitability.
For the company you selected examine the organizational structure and suggests ways it can be changed to improve the overall profitability.
Use at least five (5) quality academic resources in this assignment. Note: One of your references regarding your research should have been published within the last 6 months. Note: Wikipedia and Investopedia do not qualify as an academic resource.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
SNHU Micro Economics Imagine Your Own Business Discussion Questions
5-2 Simulation Discussion: Production, Entry, and ExitDiscussion Topic Starts Jul 24, 2021 11:59 PMNOTE THAT A CUSTOM RUBR ...
SNHU Micro Economics Imagine Your Own Business Discussion Questions
5-2 Simulation Discussion: Production, Entry, and ExitDiscussion Topic Starts Jul 24, 2021 11:59 PMNOTE THAT A CUSTOM RUBRIC IS USED FOR THIS DISCUSSION.In a competitive market, there are many buyers and sellers. The goods offered are largely the same, and firms can freely enter or exit the market. Buyers and sellers are both price takers. The amount of output produced determines the revenue of a firm.First, play the simulation game Production, Entry, and Exit in the MindTap environment. In this discussion, you will share your experiences playing that game. Your work in this discussion will directly support your success on the course project.In your initial post, include the image of your simulation report in your response. See the How to Submit a Simulation Report Image document for more information. Then, address the following questions:Imagine you own your own business. Based on what you learned from the simulation, what factors would determine your entry and exit into a market?Applying the concept of marginal costs, how would you, as a business owner, decide how much to produce?How does the impact of fixed costs change production decisions in the short run and in the long run? Refer to the average total-cost (ATC) model included in the textbook to demonstrate.In your responses, comment on at least two posts from your peers. Research and provide examples from the news of firms in perfectly competitive markets. Discuss with your peers how costs impact these firms’ profitability.To access your simulations, click the simulation link found in the module.To complete this assignment, review the Module Five Simulation Discussion Rubric.
12 pages
At.edited
Bumgardner (2019) considers the merger between AT&T and Time Warner as one of the most famous and first litigated vertical ...
At.edited
Bumgardner (2019) considers the merger between AT&T and Time Warner as one of the most famous and first litigated vertical integration cases in over ...
Similar Content
Economics Question
...
ECON372 UMASS Boston Economic System of US and Vietnam Research Paper
https://umb.umassonline.net/webapps/blackboard/content/listContent.jsp?course_id=_60847_1&content_id=_3187265_1&mode=reset...
ECON 201 Saudi Electronic University Main Causes of Unemployment Discussion
Avoid plagiarism, the work should be in your own words Students are advised to make their work clear and well presented, m...
FIN 405 SEU Finance Rho Theta Vega Concepts Questions
المملكة العربية السعودية
وزارة التعليم
الجامعة السعودية ا...
ECN 134 Net Working Capital for 2019 and 2020 for ECON Corporation Questions
https://ufile.io/o7qlqury. U must finish all financial question. Give me a word of pdf. ...
Discussion assignment
Week 4Examine a highly competitive industry (airlines, video games, fast food, soft drinks, your own field etc.) using the...
Economics Concepts In Margin Call
"Margin Call" features an investment firm on the brink of financial collapse and bankruptcy at the height of the economic ...
Journal Analysis On Antitrust Laws.edited 1
‘Apple and Epic Trial Opens with a Tour of the Fortnite Metaverse’ https://www.dropbox.com/sh/j0k8b1dj139ce17/AABCdL1O...
Opportunity Cost Assignment
There are various costs in economics. Opportunity cost is one of them. It stands for a situation where an investor has pos...
Related Tags
Book Guides
The Girl With The Dragon Tattoo
by Stieg Larsson
Girl Stop Apologizing
by Rachel Hollis
Orphan Train
by Christina Baker Kline
Normal People
by Sally Rooney
The Underground Railroad
by Colson Whitehead
All the Kings Men
by Robert Penn Warren
Invisible Man
by Ralph Ellison
The Two Towers
by J. R. R. Tolkien
Black Beauty
by Anna Sewell
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Writing Assignment: Researching Innovation, economics homework help
As a teen consumer, you are surrounded by products that have literally "changed the world" in the last five years. Wh ...
Writing Assignment: Researching Innovation, economics homework help
As a teen consumer, you are surrounded by products that have literally "changed the world" in the last five years. Whether you have an MP3 player, video game, or your own personal computer, you more than likely have access to many time-saving, innovative products. Choose one of the companies that have produced an innovative product that you use often. Then in a writing assignment that is at least two well-developed paragraphs in length, answer the following questions.1.Who was the person or team who created the company?2.As the entrepreneurs of the company, how did they combine the factors of production to make life easier or more convenient for Americans?3.Identify at least three benefits of purchasing and using this product.4.Can you think of any drawbacks or problems the company has faced or may face in the future?
Economic college
Assignment DetailsAs an employee of a company that is considering investing in a foreign economy, you have been asked to r ...
Economic college
Assignment DetailsAs an employee of a company that is considering investing in a foreign economy, you have been asked to research a country and make a presentation to your colleagues about an area of economic concern in the country. Select a country in Africa, Asia, or Latin America to research. Select 1 of the following economic concerns to research: Gross Domestic Product (GDP) Unemployment Inflation Quantities of specific goods and services Exports and importsResearch data sets for the one economic concern within the country that you have chosen. Prepare 1 presentation consisting of 10-12 Power Point slides and answer the following questions: What are 2–3 relationships between the economic concern you selected and that specific country's economy? Support your discussion of the trends with statistical evidence. Use graphs and/or data tables of the variables you chose in the discussion.What trends do you see in the data sets? Please explain. Cite all of your sources and include a reference list Your research and slides will form the basis for your Unit 4 IP paper, so please be sure to be careful and thorough in your research. Present your information, with appropriate pictures/graphics, in a PowerPoint presentation. The main topics or bullet points should appear on the slides with supporting visuals, while the Speaker Notes area (the box located at the bottom of each slide which allows you to type in notes) should be used to go into more depth regarding these main topics. Make sure the notes include information from the sources you have discovered in your research. This is very important element of your assignments as it will provide both you and your audience with supporting explanations that the bullet posts simply can’t convey.Your presentation should consist of a minimum of 12 slides of content, and the following: a title slide, an introductory slide, a conclusions slide, and a references slide. Use the following resources for assistance:Access the template provided, or create your own slideshow following the requirements listed above.Refer to the Microsoft Office website for assistance with PowerPoint: https://support.office.com/en-us/article/Basic-tasks-for-creating-a-PowerPoint-presentation-efbbc1cd-c5f1-4264-b48e-c8a7b0334e36. The Smarthinking resource is also available to assist in the basics of the PowerPoint tool.Use at least two sources when researching information to support your argument. Remember to use credible, current sources to support your presentation. Use APA reference and citation format for the sources that you use. Place citations on the relevant slides with one or two slides at the end for your reference list.
ECO550 SU Analysis of Risk Uncertainty & Managing Incentives Case Study
CASE STUDY 2: Cases Analysis of Risk, Uncertainty and Managing Incentives
Select a company of your choice, any company but ...
ECO550 SU Analysis of Risk Uncertainty & Managing Incentives Case Study
CASE STUDY 2: Cases Analysis of Risk, Uncertainty and Managing Incentives
Select a company of your choice, any company but Southwest Airlines, and write a six to eight (6-8) page paper in which you:
Evaluate a company’s recent (with in the last year) actions dealing with risk and uncertainty.
Offer advice for improving risk management.
For the company you selected examine an adverse selection problem and recommend how it should minimize its negative impact on transactions.
For the company you selected determine the ways in which it is dealing with the moral hazard problem and suggest best practices used in the industry to deal with it.
For the company you selected identify a principal-agent problem and evaluate the tools it uses to align incentives and improve profitability.
For the company you selected examine the organizational structure and suggests ways it can be changed to improve the overall profitability.
Use at least five (5) quality academic resources in this assignment. Note: One of your references regarding your research should have been published within the last 6 months. Note: Wikipedia and Investopedia do not qualify as an academic resource.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
SNHU Micro Economics Imagine Your Own Business Discussion Questions
5-2 Simulation Discussion: Production, Entry, and ExitDiscussion Topic Starts Jul 24, 2021 11:59 PMNOTE THAT A CUSTOM RUBR ...
SNHU Micro Economics Imagine Your Own Business Discussion Questions
5-2 Simulation Discussion: Production, Entry, and ExitDiscussion Topic Starts Jul 24, 2021 11:59 PMNOTE THAT A CUSTOM RUBRIC IS USED FOR THIS DISCUSSION.In a competitive market, there are many buyers and sellers. The goods offered are largely the same, and firms can freely enter or exit the market. Buyers and sellers are both price takers. The amount of output produced determines the revenue of a firm.First, play the simulation game Production, Entry, and Exit in the MindTap environment. In this discussion, you will share your experiences playing that game. Your work in this discussion will directly support your success on the course project.In your initial post, include the image of your simulation report in your response. See the How to Submit a Simulation Report Image document for more information. Then, address the following questions:Imagine you own your own business. Based on what you learned from the simulation, what factors would determine your entry and exit into a market?Applying the concept of marginal costs, how would you, as a business owner, decide how much to produce?How does the impact of fixed costs change production decisions in the short run and in the long run? Refer to the average total-cost (ATC) model included in the textbook to demonstrate.In your responses, comment on at least two posts from your peers. Research and provide examples from the news of firms in perfectly competitive markets. Discuss with your peers how costs impact these firms’ profitability.To access your simulations, click the simulation link found in the module.To complete this assignment, review the Module Five Simulation Discussion Rubric.
12 pages
At.edited
Bumgardner (2019) considers the merger between AT&T and Time Warner as one of the most famous and first litigated vertical ...
At.edited
Bumgardner (2019) considers the merger between AT&T and Time Warner as one of the most famous and first litigated vertical integration cases in over ...
Earn money selling
your Study Documents