Description
1.a. Based on your previous response in the week 3 discussion, list 3 advantages and 3 disadvantages to your selected form of ownership.
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
Good luck!
Completion Status:
100%
Review
Review
Anonymous
Very useful material for studying!
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
6 pages
Democratic Leadership Style
Leadership style entails the action of guiding, directing, motivating, and managing others. Various types of leaders are c ...
Democratic Leadership Style
Leadership style entails the action of guiding, directing, motivating, and managing others. Various types of leaders are categorized across multiple ...
7 pages
Tesla Toyota
The analysis presented here focusses on the automotive industry. The organizations chosen are Tesla and Toyota which provi ...
Tesla Toyota
The analysis presented here focusses on the automotive industry. The organizations chosen are Tesla and Toyota which provide unique opportunities for ...
CTU Wk 2 Differences on Social & Economic Performance BW Chicago & US in General PPT
You will need to become familiar with specialized business intelligence (BI) software, and then download the software. Com ...
CTU Wk 2 Differences on Social & Economic Performance BW Chicago & US in General PPT
You will need to become familiar with specialized business intelligence (BI) software, and then download the software. Complete the following steps to begin:
Step 1: Watch an instructional video on the BI software.
Step 2: Review various BI Software options, including Tableau and Excel. Search the CTU Library and the Internet to learn about optional software.
Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any BI software to create a graph illustrating comparison between the United States and zip code data.
Consider the following scenario, continued from Unit 1 Individual Project:
Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the business analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets to make the best recommendation possible. Complete the following:
Download the reports for the United States from this Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports:
General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary (based on the entire United States)
Download the reports for zip code 60614 from this Web site. This particular file contains 4 reports:
General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary based on the U.S. zip code 60614
Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page summary slide explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in the data.
Use the BI software you choose to depict information from these reports.
Prepare a presentation of 4–5 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least 2 graphs and a headline that summarizes a key takeaway from the graph.
Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (75-word minimum per slide).
For assistance with the usage of Tableau for analysis and reporting, review and use the instructions below. Those should be helpful if you are having problems with the software usage or data. However, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the Internet and in videos to learn how to use Excel to create graphical presentations including table usage.
The instructions to create a bar graph in Tableau (optional) or in another BI software are as follows.
Open the assignment CTU instructions.
Download the BI software.
Create your Tableau Public Account.
Click the download link for the 60614 file (file will open in Excel).
Click the download link for the U.S. file (file will open in Excel).
The following are some options:
Create separate demographical worksheets (e.g., Educational Attainment or Household Income). Include zip code and U.S. data.
See a sample of the file available with column headings and extraneous blanks.
Household IncomeChicagoU.S.198019901980 to 199020001990 to 20001980Median Household Income18,43841,2271.23669,3110.68116,902Average household Income24,24567,6071.788114,6150.69520,382Per Capita Income13,56438,5181.8463,7910.6567,321
See a sample of the file available with column headings and extraneous blanks.
2000 Educational AttainmentU.S.ChicagoCollege: Associates Degree6.3%1.9%College: Bachelor's Degree15.5%44.2%College: Graduate Degree8.9%34.0%College: Some College, no Degree21.1%8.7%School: 9th to 11th grade, no diploma12.1%3.2%School: Grade K-96.1%2.0%School: High School Graduate28.6%5.6%
Create a file with data organized without extraneous rows and columns but including headings.
The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
Note that in the real situation, when using BI software, you will want to ensure that your data are clean and that you have similar data in your files.
Save the file(s) on your computer.
Open Tableau. Then do a File > Open > Open on your saved file.
At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner).
Under “Measures” (on the left), you should see “Chicago” and “U.S.” Click on “U.S.,” and pull it into rows at the top of the screen. Then, click on Chicago and pull it over into rows.
Under “Dimensions” on the left, you should see “Household Income.” Click on “Household Income,” and pull it into column.
In the second column from the left, you should see “Measures.”
In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data.
To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in Tableau Public.)
After the file is saved, open the .png file, and edit or copy the graph.
Open your PowerPoint file, and then paste (special) it on the slide. You can adjust the size.
Repeat the same in Tableau opening of any other prepped and cleaned file.
Note: Measure values are your number fields; measure names are the descriptors.
For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.
Additional Resources to Use
American Marketing Association. (n.d.). Summary reports. Retrieved from http:/www.marketingpower.com/content753.php
Igines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video file]. Retrieved from
Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-...
Portfolio?
Exotic Food Inc., Capital Budgeting CaseCASE SUMMARYExotic Food Inc., a food processing company located in Herndon, VA, is ...
Portfolio?
Exotic Food Inc., Capital Budgeting CaseCASE SUMMARYExotic Food Inc., a food processing company located in Herndon, VA, is considering adding a new division to produce fresh ginger juice. Following the ongoing TV buzz about significant health benefits derived from ginger consumption, the managers believe this drink will be a hit. However, the CEO questions the profitability of the venture given the high costs involved. To address his concerns, you have been asked to evaluate the project using three capital budgeting techniques (i.e., NPV, IRR and Payback) and present your findings in a report.CASE OVERVIEWThe main equipment required is a commercial food processor which costs $200,000. The shipping and installation cost of the processor from China is $50,000. The processor will be depreciated under the MACRS system using the applicable depreciation rates are 33%, 45%, 15%, and 7% respectively. Production is estimated to last for three years, and the company will exit the market before intense competition sets in and erodes profits. The market value of the processor is expected to be $100,000 after three years. Net working capital of $2,000 is required at the start, which will be recovered at the end of the project. The juice will be packaged in 20 oz. containers that sell for $3.00 each. The company expects to sell 150,000 units per year; cost of goods sold is expected to total 70% of dollar sales. Weighted Average Cost of Capital (WACC):Exotic Food’s common stock is currently listed at $75 per share; new preferred stock sells for $80 per share and pays a dividend of $5.00. Last year, the company paid dividends of $2.00 per share for common stock, which is expected to grow at a constant rate of 10%. The local bank is willing to finance the project at 10.5% annual interest. The company’s marginal tax rate is 35%, and the optimum target capital structure is:Common equity50%Preferred20%Debt30%Your main task is to compute and evaluate the cash flows using capital budgeting techniques, analyze the results, and present your recommendations whether the company should take on the project.QUESTIONSTo help in the analysis, answer all the following questions. Present the analysis in one Excel file with the data, computations, formulas, and solutions. It is preferred that the Excel file be embedded inside the WORD document (question 8).What is the total investment amount at the start of the project (i.e., year zero cash flow)?What is the depreciation amount for each year?Create a depreciation scheduleWhat is the after-tax salvage value of the equipment?What is the projected net income and Operating Cash Flows (OCF) for the three years?Complete an income statement for each year.What are the Free Cash Flows (FCF) generated from the project?Create a projected cash flow scheduleWhat is the Weighted Average Cost of Capital (WACC)?Compute the after-tax cost of debtCompute the cost of common equityCompute the cost of preferred stockCompute the Weighted Average Cost of Capital (WACC)Using a WACC of 15%, apply four capital budgeting techniques to evaluate the project, assuming the Free Cash Flows are as follows:YearsFree Cash Flows0$ -252,000.001$118,625.002$127,125.003$181,000.00The four techniques are NPV, IRR, MIRR, and discounted Payback. Assume the reinvestment rate to be 8% for the MIRR. Also, assume that the business will only accept projects with a payback period of two and half years or less.Present your findings in a report to the CEO with recommendations as to whether the project should be accepted or rejected based on the four criteria. Your analysis should include a discussion of the decision-making rules for each method. A two-page Word file with the analysis and recommendations written using APA writing style, according to the CSU-Global Guide to Writing and APA Requirements.
Similar Content
Research paper topic: Texas Legends on George H. W. Bush
Research paper topic: Texas Legends (George H.W. Bush)Your assignment is to write a description of a unique person or even...
RC Debt the Only Component of Disneys Capital Structure Discussion
Having the right mix of investments is a key piece in maximizing the firm's value. For this discussion, take a look at Dis...
Colorado State University Chapter 3 Microculture and Cultural Dimensions HW
describe information regarding a “microculture” of your choice. Look to Chapter 3 for an in-depth description of a “...
1 dq 1 paper business management
These are 2 separate assignments must do them both. The first one is 2 to 3 pages as well as the
second one
Library Rese...
REL 134 UOP Business Characteristics of Alternative Religions Worksheet
REL/134 v8
Characteristics of Alternative Religions
In this assignment, you will share what you learned about 3 chosen al...
Identifying Single, Double, and Multiple Feedback Loops
Identifying Single, Double, and Multiple Feedback Loops The concept of feedback loops is critical to systems thinking and...
Management Final
Main difference between CAPM) and the Arbitrage Pricing Theory Capital Asset Pricing model quantifies investors return on...
Focused improvement class lectures_7378709-13-August-English-Improvement
uploads/services/161584/Focused improvement class lectures_7378709-13-August-English-Improvement.pdf...
Credit Risk Solution
The quantification of credit risk while assigning measurable and numbers that can be compared to the probability of a defa...
Related Tags
Book Guides
The Visible Filth
by Nathan Ballingrud
American Gods
by Neil Gaiman
12 Rules for Life
by Jordan Peterson
Homo Deus
by Yuval Noah Harari
How to Win at the Sport of Business
by Mark Cuban
Where the Crawdads Sing
by Delia Owens
Dandelion Wine
by Ray Bradbury
Harry Potter and the Sorcerers Stone
by J. K. Rowling
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
6 pages
Democratic Leadership Style
Leadership style entails the action of guiding, directing, motivating, and managing others. Various types of leaders are c ...
Democratic Leadership Style
Leadership style entails the action of guiding, directing, motivating, and managing others. Various types of leaders are categorized across multiple ...
7 pages
Tesla Toyota
The analysis presented here focusses on the automotive industry. The organizations chosen are Tesla and Toyota which provi ...
Tesla Toyota
The analysis presented here focusses on the automotive industry. The organizations chosen are Tesla and Toyota which provide unique opportunities for ...
CTU Wk 2 Differences on Social & Economic Performance BW Chicago & US in General PPT
You will need to become familiar with specialized business intelligence (BI) software, and then download the software. Com ...
CTU Wk 2 Differences on Social & Economic Performance BW Chicago & US in General PPT
You will need to become familiar with specialized business intelligence (BI) software, and then download the software. Complete the following steps to begin:
Step 1: Watch an instructional video on the BI software.
Step 2: Review various BI Software options, including Tableau and Excel. Search the CTU Library and the Internet to learn about optional software.
Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any BI software to create a graph illustrating comparison between the United States and zip code data.
Consider the following scenario, continued from Unit 1 Individual Project:
Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the business analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets to make the best recommendation possible. Complete the following:
Download the reports for the United States from this Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports:
General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary (based on the entire United States)
Download the reports for zip code 60614 from this Web site. This particular file contains 4 reports:
General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary based on the U.S. zip code 60614
Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page summary slide explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in the data.
Use the BI software you choose to depict information from these reports.
Prepare a presentation of 4–5 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least 2 graphs and a headline that summarizes a key takeaway from the graph.
Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (75-word minimum per slide).
For assistance with the usage of Tableau for analysis and reporting, review and use the instructions below. Those should be helpful if you are having problems with the software usage or data. However, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the Internet and in videos to learn how to use Excel to create graphical presentations including table usage.
The instructions to create a bar graph in Tableau (optional) or in another BI software are as follows.
Open the assignment CTU instructions.
Download the BI software.
Create your Tableau Public Account.
Click the download link for the 60614 file (file will open in Excel).
Click the download link for the U.S. file (file will open in Excel).
The following are some options:
Create separate demographical worksheets (e.g., Educational Attainment or Household Income). Include zip code and U.S. data.
See a sample of the file available with column headings and extraneous blanks.
Household IncomeChicagoU.S.198019901980 to 199020001990 to 20001980Median Household Income18,43841,2271.23669,3110.68116,902Average household Income24,24567,6071.788114,6150.69520,382Per Capita Income13,56438,5181.8463,7910.6567,321
See a sample of the file available with column headings and extraneous blanks.
2000 Educational AttainmentU.S.ChicagoCollege: Associates Degree6.3%1.9%College: Bachelor's Degree15.5%44.2%College: Graduate Degree8.9%34.0%College: Some College, no Degree21.1%8.7%School: 9th to 11th grade, no diploma12.1%3.2%School: Grade K-96.1%2.0%School: High School Graduate28.6%5.6%
Create a file with data organized without extraneous rows and columns but including headings.
The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
Note that in the real situation, when using BI software, you will want to ensure that your data are clean and that you have similar data in your files.
Save the file(s) on your computer.
Open Tableau. Then do a File > Open > Open on your saved file.
At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner).
Under “Measures” (on the left), you should see “Chicago” and “U.S.” Click on “U.S.,” and pull it into rows at the top of the screen. Then, click on Chicago and pull it over into rows.
Under “Dimensions” on the left, you should see “Household Income.” Click on “Household Income,” and pull it into column.
In the second column from the left, you should see “Measures.”
In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data.
To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in Tableau Public.)
After the file is saved, open the .png file, and edit or copy the graph.
Open your PowerPoint file, and then paste (special) it on the slide. You can adjust the size.
Repeat the same in Tableau opening of any other prepped and cleaned file.
Note: Measure values are your number fields; measure names are the descriptors.
For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.
Additional Resources to Use
American Marketing Association. (n.d.). Summary reports. Retrieved from http:/www.marketingpower.com/content753.php
Igines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video file]. Retrieved from
Microsoft. (2018). Create a chart from start to finish. Retrieved from https://support.office.com/en-us/article/Create-a-...
Portfolio?
Exotic Food Inc., Capital Budgeting CaseCASE SUMMARYExotic Food Inc., a food processing company located in Herndon, VA, is ...
Portfolio?
Exotic Food Inc., Capital Budgeting CaseCASE SUMMARYExotic Food Inc., a food processing company located in Herndon, VA, is considering adding a new division to produce fresh ginger juice. Following the ongoing TV buzz about significant health benefits derived from ginger consumption, the managers believe this drink will be a hit. However, the CEO questions the profitability of the venture given the high costs involved. To address his concerns, you have been asked to evaluate the project using three capital budgeting techniques (i.e., NPV, IRR and Payback) and present your findings in a report.CASE OVERVIEWThe main equipment required is a commercial food processor which costs $200,000. The shipping and installation cost of the processor from China is $50,000. The processor will be depreciated under the MACRS system using the applicable depreciation rates are 33%, 45%, 15%, and 7% respectively. Production is estimated to last for three years, and the company will exit the market before intense competition sets in and erodes profits. The market value of the processor is expected to be $100,000 after three years. Net working capital of $2,000 is required at the start, which will be recovered at the end of the project. The juice will be packaged in 20 oz. containers that sell for $3.00 each. The company expects to sell 150,000 units per year; cost of goods sold is expected to total 70% of dollar sales. Weighted Average Cost of Capital (WACC):Exotic Food’s common stock is currently listed at $75 per share; new preferred stock sells for $80 per share and pays a dividend of $5.00. Last year, the company paid dividends of $2.00 per share for common stock, which is expected to grow at a constant rate of 10%. The local bank is willing to finance the project at 10.5% annual interest. The company’s marginal tax rate is 35%, and the optimum target capital structure is:Common equity50%Preferred20%Debt30%Your main task is to compute and evaluate the cash flows using capital budgeting techniques, analyze the results, and present your recommendations whether the company should take on the project.QUESTIONSTo help in the analysis, answer all the following questions. Present the analysis in one Excel file with the data, computations, formulas, and solutions. It is preferred that the Excel file be embedded inside the WORD document (question 8).What is the total investment amount at the start of the project (i.e., year zero cash flow)?What is the depreciation amount for each year?Create a depreciation scheduleWhat is the after-tax salvage value of the equipment?What is the projected net income and Operating Cash Flows (OCF) for the three years?Complete an income statement for each year.What are the Free Cash Flows (FCF) generated from the project?Create a projected cash flow scheduleWhat is the Weighted Average Cost of Capital (WACC)?Compute the after-tax cost of debtCompute the cost of common equityCompute the cost of preferred stockCompute the Weighted Average Cost of Capital (WACC)Using a WACC of 15%, apply four capital budgeting techniques to evaluate the project, assuming the Free Cash Flows are as follows:YearsFree Cash Flows0$ -252,000.001$118,625.002$127,125.003$181,000.00The four techniques are NPV, IRR, MIRR, and discounted Payback. Assume the reinvestment rate to be 8% for the MIRR. Also, assume that the business will only accept projects with a payback period of two and half years or less.Present your findings in a report to the CEO with recommendations as to whether the project should be accepted or rejected based on the four criteria. Your analysis should include a discussion of the decision-making rules for each method. A two-page Word file with the analysis and recommendations written using APA writing style, according to the CSU-Global Guide to Writing and APA Requirements.
Earn money selling
your Study Documents