HW 2. Hanh Do
xlsx
keyboard_arrow_up
School
Palm Beach State College *
*We aren’t endorsed by this school
Course
4604
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
16
Uploaded by MasterWildcat4249
MANAGERIAL FINANCE HOMEWORK #2
Summary of Homework #2
There are 4 questions in this assignment. Points assigned to each question are shown below:
Q1: 1 point
Q2: 1 point
Q3: 1 point
Q4: 1 point
Total = 4 points
This assignment can be completed based on group effort.
Do not forget to put your name(s) in the appropriate cells (shown right) in alphabetical order.
If you have any questions, please feel free to contact me.
GRBA 811
Member
Last name
First name
1
2
3
4
5
6
Part A: Give an example for diversifiable risk.
Answer:
Part B: Give an example for undiversifiable risk.
Answer:
Part C: Using layman terms please explain the meaning of beta.
Answer:
Part D: As beta increases, what happens to risk (increase or decrease)? Please provide an intuitive answer
Answer:
Part E: Please examine SML equation (6-15) on page 264 and figure 6-9 on page 266. Suppose that you ha
that risk-free rate and market risk-premium are 4% and 10% respectively. What is the required return on would be the required return? Assuming that you correctly answered the latter part and got a negative nu
how come a risky asset can have negative required return? Why would investors ever want to hold this st
Answer:
Part F: The following data presents the monthly returns for XYZ Industries and S&P500 during the past fiv
regressing XYZ Returns (dependent variable or Y-values) on S&P 500 Returns (independent variable or X-v
use the "SLOPE" function or use the "Data Analysis" module under "Data" tab.
Date
XYZ Returns
S&P500 Returns
2/1/2007
-1.28%
-1.96%
3/1/2007
1.34%
1.16%
4/2/2007
0.68%
4.43%
5/1/2007
3.98%
3.39%
6/1/2007
-2.88%
-1.46%
7/2/2007
-8.57%
-3.13%
8/1/2007
1.86%
1.28%
MANAGERIAL FINANCE HOMEWORK #2
Question 1-Conceptual questions (Hint: Review Chapter 6)
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
9/4/2007
0.49%
3.87%
10/1/2007
1.06%
1.35%
11/1/2007
-7.37%
-3.87%
12/3/2007
-1.94%
-1.12%
1/2/2008
-3.84%
-6.05%
2/1/2008
-3.17%
-2.59%
3/3/2008
-0.07%
-0.89%
4/1/2008
3.95%
4.77%
5/1/2008
3.11%
1.51%
6/2/2008
-9.34%
-8.36%
7/1/2008
4.01%
-0.90%
8/1/2008
5.22%
1.54%
9/2/2008
-3.21%
-9.41%
10/1/2008
-20.97%
-16.52%
11/3/2008
-11.26%
-6.96%
12/1/2008
5.27%
0.97%
1/2/2009
-13.78%
-8.21%
2/2/2009
-13.89%
-10.74%
3/2/2009
8.69%
8.32%
4/1/2009
15.37%
9.93%
5/1/2009
2.36%
5.84%
6/1/2009
-0.16%
-0.06%
7/1/2009
11.27%
7.46%
8/3/2009
5.07%
3.69%
9/1/2009
4.67%
3.55%
10/1/2009
-6.32%
-1.92%
11/2/2009
2.63%
6.16%
12/1/2009
7.67%
1.92%
1/4/2010
-2.77%
-3.64%
2/1/2010
4.53%
3.12%
3/1/2010
8.51%
5.65%
4/1/2010
6.82%
1.55%
5/3/2010
-8.25%
-7.95%
6/1/2010
-8.83%
-5.18%
7/1/2010
7.08%
6.84%
8/2/2010
-7.51%
-4.50%
9/1/2010
10.71%
8.96%
10/1/2010
3.84%
3.82%
11/1/2010
2.62%
0.00%
12/1/2010
8.33%
6.69%
1/3/2011
-0.13%
2.33%
2/1/2011
5.10%
3.47%
3/1/2011
1.35%
0.02%
4/1/2011
1.62%
2.90%
5/2/2011
-1.70%
-1.13%
6/1/2011
-2.50%
-1.69%
7/1/2011
-3.17%
-2.00%
8/1/2011
-9.11%
-5.50%
9/1/2011
-10.84%
-6.94%
10/3/2011
14.47%
10.91%
11/1/2011
-0.20%
-0.41%
12/1/2011
1.41%
1.05%
1/3/2012
5.36%
4.75%
GRBA 811
r (layman terms please)?
ave a stock with a beta of 0.5 . Also assume
this stock? If the beta were -0.5, what umber then please explain tock?
ve years. Please estimate XYZ's beta by
values. To run a regression on Excel you can either
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
Answer:
MANAGERIAL FINANCE HOMEWORK #2
Question 2-Bond basics (Hint: Review Chapter 5)
A 25-year, $1,000 par value bond has a 7% annual coupon. The bond currently sells for $800. If the yield to
price be 7 years from now?
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
GRBA 811
o maturity remains at its current rate, what will the
Answer:
MANAGERIAL FINANCE HOMEWORK #2
Question 3-Bond basics (Hint: Review Chapter 5)
Huskers Industries has a bond outstanding with 20 years to maturity, a 9% coupon paid semiannually, be called in 7 years at a price of $1,030. What is the bond’s nominal yield to call?
GRBA 811
and a $1,000 par value. The bond has an 8.0% nominal yield to maturity, but it can
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
2011
2012
2013
Revenue
$50,000 COGS (Excludes depreciation expense)
$36,750 Depreciation expense
$5,000 EBIT
$8,250 Interest expense $2,000 EBT
$6,250 Taxes (20%)
$1,250 Net income
$5,000 Dividends
0
Assets
2011
2012
2013
Cash
$10,000 Accounts receivable
$30,000 Gross PP&E
$50,000 Less accumulated depreciation
$10,000 Net PP&E
$40,000 Total assets
$80,000 Liabilities and Equity
Accounts payable
$30,000 Bank debt
0
Long-term debt
$20,000 Common stock
$20,000 Retained earnings
$10,000 Total L+E
$80,000 MANAGERIAL FINANCE HOMEWORK #2
Question 4- Basic FS Forecasting
Huskers Inc. is considering a one-time investment in property, plant and equipment amounting to $40,000 (Assu
at an annualized rate of 15% during the next two years. Currently, Huskers Inc. does not carry short-term bank d
statement and balance sheet to compute the bank debt balance for years 2012 and 2013. Bank debt picks up re
corporate credit card account or more properly "line of credit").
- Annual sales growth will be 15% .
- Annual COGS will be 70% of annual revenues.
- Annual depreciation expense will be 10% of the annual gross PP&E fiscal year-end balance.
- Interest rate on all types of debt is 10% and the annual interest expense is computed as 10% of the previous ye
- Company will pay $2,000 per year in dividends during the next two years.
- Fiscal year-end cash balance will be 15% of annual revenues.
- Fiscal year-end accounts receivable balance will be 60% of annual revenues.
- There will be no other capital expenditures during the next two years other than the $40,000 that will occur at
- Fiscal year-end accounts payable will be 60% of annual revenues.
- Long-term debt balance will remain at $20,000 during the next two years.
- Company will not issue equity during the next two years.
GRBA 811
ume today is the last day of 2011). This new investment is expected to increase revenues debt. Using all
of the below assumptions, fill in the blanks on the proforma income emaining financing needs of the firm after accounting for everything else (i.e. it is like a ear’s interest bearing debt balance (=bank debt + long-term debt).
t the beginning of 2012.
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 Documents
Related Questions
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
arrow_forward
Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
Make a textual information from this Enrollment by Key Stage
arrow_forward
Please use the workbook page, it has the steps on how to solve the problems.
arrow_forward
myOpenMath
Course Messages Forums Calendar | Gradebook
Home > Math 173-4 Spring 2024> Assessment
Quiz 2 (Sec. 1.5-1.7)
54 points possible 5/12 answered
Question 6
The graph of the function
y = f(x - 39)
can be obtained from the graph of
y = f(x)
by one of the following actions:
> Next Question
Home | My
Oshifting the graph of f(x) to the right 39 units
shifting the graph of f(x) to the left 39 units
shifting the graph of f(x) upwards 39 units
shifting the graph of f(x) downwards 39 units
arrow_forward
I Need Help Finding Row 13 and 14
The Income Summary And Retained Earnings
arrow_forward
I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance.
arrow_forward
Please see below. Need help with this asap please and thank you.
arrow_forward
Need help in feeling out the chart. Thank you
arrow_forward
A
B
C
D
E
F
G
K
M
N O
P
Formula: Divide; Cell Referencing
Using Excel to Perform Vertical Analysis
Student Work Area
PROBLEM
Required: Provide input into cells shaded in yellow in this template. Use mathematical
formulas with cell references to this work area.
Data from the comparative balance sheets of Rollaird Company is
presented here.
December 31,
December 31,
Using these data from the comparative balance sheets of Rollaird Company, perform vertical
analysis.
2022
2021
Accounts receivable (net)
2$
460,000 $
400,000
1.
December 31, 2021
Inventory
Total assets
780,000
650,000
December 31, 2022
3,164,000
2,800,000
Amount
Percent
Amount
Percent
Accounts receivable (net)
$ 460,000
$
400,000
Inventory
780,000
650,000
Total assets
3,164,000
2,800,000
arrow_forward
You are considering the following two projects and can take only one. Your cost of capital is
10.7%. The cash flows for the two projects are as follows ($ million):
a. What is the IRR of each project?
b. What is the NPV of each project at your cost of capital?
c. At what cost of capital are you indifferent between the two projects?
d. What should you do?
a. What is the IRR of each project?
The IRR for project A is%. (Round to one decimal place.)
arrow_forward
Hello just explain how to get the first one, then i'll do the restt. thank youu
arrow_forward
Can you explain how to do this
arrow_forward
I need help finishing the rest of the problem.
arrow_forward
E Chapter 5 Homework - FINANCIA X
O NWP Assessment Player UI Appli X
b Answered: The accountant of Lati x
M Inbox - dhyani11141999@gmail. X
b My Questions | bartleby
+
i assessment.education.wiley.com/was/ui/v2/assessment-player/index.html?launchld=1d52287e-dfd8-4d2a-80c9-4cbf51a01297#/question/5
E Chapter 5 Homework
Question 6 of 6
>
-/ 1
View Policies
Current Attempt in Progress
The comparative balance sheets of Constantine Cavamanlis Inc. at the beginning and the end of the year 2020 are as follows.
CONSTANTINE CAVAMANLIS INC.
BALANCE SHEETS
Dec. 31, 2020
Jan. 1, 2020
Inc./Dec.
Assets
Cash
$ 45,000
$ 13,000
$32,000
Inc.
Accounts receivable
91,000
88,000
3,000
Inc.
Equipment
39,000
22,000
17,000
Inc.
Less: Accumulated Depreciation-Equipment
17,000
11,000
6,000
Inc.
Total
$158,000
$112,000
Liabilities and Stockholders' Equity,
Accounts payable
$ 20,000
$ 15,000
5,000
Inc.
Common stock
100,000
80,000
20,000
Inc.
Retained earnings
38,000
17,000
21,000
Inc.
Total
$158,000
$112,000
Net…
arrow_forward
Hi I need help on what is the answer to this problems? Below is the question and other concerns will be in the comment section. I hope you can help me and surely I will give you full positive feedback
arrow_forward
Learning
SE MINDTAP
evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆
lomework
6300.
1
mancial Lailuialvi vi a spicoubnicel.
Hide Feedback
Correct
X
f6
Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan
to make your first deposit one year from today.
a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent.
4
b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations.
Round your answer to the nearest cent.
6
Hide Feedback
Incorrect
F
Check My Work Feedback
Review the FVAN definition and its equation.
Q Search
Understand the difference between an ordinary annuity and an annuity due.
Be careful about the order of mathematical operations if using the equation.
If using a financial calculator, be…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- 1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…arrow_forwardHi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?arrow_forwardDirections 1 Given cose = 2, and is in Quadrant 1, what is tane? You must show all of your work to receive credit for this problem. Please choose one option to complete this activity. Sketchpad FILE UPLOAD i Question 7 OR 1 File Upload Upload your work. Show all steps to receive credit for this problem.arrow_forward
- Make a textual information from this Enrollment by Key Stagearrow_forwardPlease use the workbook page, it has the steps on how to solve the problems.arrow_forwardmyOpenMath Course Messages Forums Calendar | Gradebook Home > Math 173-4 Spring 2024> Assessment Quiz 2 (Sec. 1.5-1.7) 54 points possible 5/12 answered Question 6 The graph of the function y = f(x - 39) can be obtained from the graph of y = f(x) by one of the following actions: > Next Question Home | My Oshifting the graph of f(x) to the right 39 units shifting the graph of f(x) to the left 39 units shifting the graph of f(x) upwards 39 units shifting the graph of f(x) downwards 39 unitsarrow_forward
- I Need Help Finding Row 13 and 14 The Income Summary And Retained Earningsarrow_forwardI need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance.arrow_forwardPlease see below. Need help with this asap please and thank you.arrow_forward
- Need help in feeling out the chart. Thank youarrow_forwardA B C D E F G K M N O P Formula: Divide; Cell Referencing Using Excel to Perform Vertical Analysis Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area. Data from the comparative balance sheets of Rollaird Company is presented here. December 31, December 31, Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. 2022 2021 Accounts receivable (net) 2$ 460,000 $ 400,000 1. December 31, 2021 Inventory Total assets 780,000 650,000 December 31, 2022 3,164,000 2,800,000 Amount Percent Amount Percent Accounts receivable (net) $ 460,000 $ 400,000 Inventory 780,000 650,000 Total assets 3,164,000 2,800,000arrow_forwardYou are considering the following two projects and can take only one. Your cost of capital is 10.7%. The cash flows for the two projects are as follows ($ million): a. What is the IRR of each project? b. What is the NPV of each project at your cost of capital? c. At what cost of capital are you indifferent between the two projects? d. What should you do? a. What is the IRR of each project? The IRR for project A is%. (Round to one decimal place.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning