FIN
350 Complete Class-GC
Click Link Below To Buy:
Contact Us:
Hwcoursehelp@gmail.com
FIN 350 Complete Class
FIN350
FIN 350 Week 1 Module 1 Practice Problems
Complete the following problems from the textbook:
• Chapter 1, P1-2
• Chapter 2, P2-4, P2-6, and Integrative Case 1
Follow these instructions for completing and submitting your
assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not
submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in “Guidelines for Developing
Spreadsheets.”
You are not required to submit this assignment to Turnitin.
FIN 350 Week 2 Module 2 Practice Problems
Complete the following problems from chapter 3 in the textbook:
• P3-3
• P3-6
• P3-10
• P3-16
• P3-18
• P3-20
• P3-21
Follow these instructions for completing and submitting your
assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not
submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in “Guidelines for Developing
Spreadsheets.”
You are not required to submit this assignment to Turnitin.
FIN 350 Week 3 Module 3 Practice Problems
P4–5 Classifying inflows and outflows of cash Classify each of the
following items as an inflow (I) or an outflow (O) of cash, or as neither (N).
P4–6 Finding operating and free cash flows Consider the following
balance sheets and selected data from the income statement of Keith
Corporation.
a. Calculate the firm’s net operating profit after taxes (NOPAT)
for the year ended December 31, 2015, using Equation 4.1.
b. Calculate the firm’s operating cash flow (OCF) for the year
ended December 31, 2015, using Equation 4.3.
c. Calculate the firm’s free cash flow (FCF) for the year ended
December 31, 2015, using Equation 4.4.
d. Interpret, compare, and contrast your cash flow estimates in
parts b and c.
P4–9 Cash budget: Basic Grenoble Enterprises had sales of $50,000
in March and $60,000 in April. Forecast sales for May, June, and July are
$70,000, $80,000, and $100,000, respectively. The firm has a cash balance of
$5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given
the following data, prepare and interpret a cash budget for the months of May,
June, and July.
(1) The firm makes 20% of sales for cash, 60% are collected in the
next month, and the remaining 20% are collected in the second month following
sale.
(2) The firm receives other income of $2,000 per month.
(3) The firm’s actual or expected purchases, all made for cash,
are $50,000, $70,000, and $80,000 for the months of May through July,
respectively.
(4) Rent is $3,000 per month.
(5) Wages and salaries are 10% of the previous month’s sales.
(6) Cash dividends of $3,000 will be paid in June.
(7) Payment of principal and interest of $4,000 is due in June.
(8) A cash purchase of equipment costing $6,000 is scheduled in
July.
(9) Taxes of $6,000 are due in June.
P4–15 Pro forma income statement The marketing department of
Metroline Manufacturing estimates that its sales in 2016 will be $1.5 million.
Interest expense is expected to remain unchanged at $35,000, and the firm plans
to pay $70,000 in cash dividends during 2016. Metroline Manufacturing’s income
statement for the year ended December 31, 2015, and a breakdown of the firm’s
cost of goods sold and operating expenses into their fixed and variable components
are given below.
a. Use the percent-of-sales method to prepare a pro forma income
statement for the year ended December 31, 2016.
b. Use fixed and variable cost data to develop a pro forma income
statement for the year ended December 31, 2016.
c. Compare and contrast the statements developed in parts a and b.
Which statement probably provides the better estimate of 2016 income? Explain
why.
P4–18 Pro forma balance sheet Peabody & Peabody has 2015 sales
of $10 million. It wishes to analyze expected performance and financing needs
for 2017, which is 2 years ahead. Given the following information, respond to
parts a and b.
(1) The percents of sales for items that vary directly with sales
are as follows: Accounts receivable, 12% Inventory, 18% Accounts payable, 14%
Net profit margin, 3%
(2) Marketable securities and other current liabilities are
expected to remain unchanged.
(3) A minimum cash balance of $480,000 is desired.
(4) A new machine costing $650,000 will be acquired in 2016, and
equipment costing $850,000 will be purchased in 2017. Total depreciation in
2016 is forecast as $290,000, and in 2017 $390,000 of depreciation will be
taken.
(5) Accruals are expected to rise to $500,000 by the end of 2017.
(6) No sale or retirement of long-term debt is expected.
(7) No sale or repurchase of common stock is expected.
(8) The dividend payout of 50% of net profits is expected to
continue.
(9) Sales are expected to be $11 million in 2016 and $12 million
in 2017.
(10) The December 31, 2015, balance sheet follows.
a. Prepare a pro forma balance sheet dated December 31, 2017.
b. Discuss the financing changes suggested by the statement
prepared in part a.
FIN 350 Week 4 Module 4 Practice Problems
Complete the following problems from chapter 5 in the textbook:
• P5-2
• P5-6
• P5-14
• P5-22
• P5-29
• P5-39
Follow these instructions for completing and submitting your
assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not
submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in “Guidelines for Developing
Spreadsheets.”
You are not required to submit this assignment to Turnitin.
FIN 350 Week 5 Module 5 Practice Problems
Complete the following problems from chapter 6 in the textbook:
• P6-5
• P6-11
• P6-17
• P6-18
• P6-22
Follow these instructions for completing and submitting your
assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not
submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in “Guidelines for Developing
Spreadsheets.”
You are not required to submit this assignment to Turnitin.
FIN 350 Week 6 Module 6 Practice Problems
Complete the following problems from chapter 7 in the textbook:
• P7-2
• P7-8
• P7-10
• P7-14
• P7-17
• P7-19
Follow these instructions for completing and submitting your
assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not
submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in “Guidelines for Developing
Spreadsheets.”
You are not required to submit this assignment to Turnitin.
FIN 350 Week 7 Module 7 Practice Problems
Follow these instructions for completing and submitting your
assignment:
1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not
submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in the “Guidelines for Developing
Spreadsheets.”
P8–9 Rate of return, standard deviation, and coefficient of
variation Mike is searching
for a stock to include in his current stock portfolio. He is
interested in Hi-Tech,
Inc.; he has been impressed with the company’s computer products
and believes
that Hi-Tech is an innovative market player. However, Mike
realizes that any
time you consider a technology stock, risk is a major concern. The
rule he follows
is to include only securities with a coefficient of variation of
returns below 0.90.
Mike has obtained the following price information for the period
2012 through
2015. Hi-Tech stock, being growth-oriented, did not pay any
dividends during these
4 years.
Stock price
Year Beginning End
2012 $14.36 $21.55
2013 21.55 64.78
2014 64.78 72.38
2015 72.38 91.80
a. Calculate the rate of return for each year, 2012 through 2015,
for Hi-Tech stock.
b. Assume that each year’s return is equally probable, and
calculate the average return
over this time period.
c. Calculate the standard deviation of returns over the past 4
years. (Hint: Treat
these data as a sample.)
d. Based on b and c, determine the coefficient of variation of
returns for the security.
e. Given the calculation in d, what should be Mike’s decision
regarding the inclusion
of Hi-Tech stock in his portfolio?
P8–14 Portfolio analysis You have been given the expected return
data shown in the first
No comments:
Post a Comment