FIN 419 Week 4 Team Assignment Problem Sets
$12.00

FIN 419 Week 4 Team Assignment Problem Sets

This Tutorial was purchased 13 times & rated A by student like you.

 

This Tutorial contains following Attachments

  • FIN 419 cc Week 4 Team Assignment Problem Sets.docx
  • FIN 419 cc Week 4 Team Assignment Problem Sets.xlsx

In case different Questions/problems are asked by your instructor just email me Complete the following problem sets in Financial Management using Microsoft® Excel®: • Chapter 7 : 5, 15 • Chapter 9 : 10 • Chapter 11 : 12 • Chapter 16: 9, 10 Chapter 7 5. King Waterbeds has an annual cash dividend policy that raises the dividend each year by 4%. Last year’s dividend was $0.40 per share. What is the price of this stock if a. an investor wants a 5% return? b. an investor wants an 8% return? c. an investor wants a 10% return? d. an investor wants a 13% return? e. an investor wants a 20% return? 15. Using Yahoo! Finance (http://finance.yahoo.com/) and ticker symbol PEP, find PepsiCo’s historical dividend payment and current price. Historical dividends are available in the historical price section. Use these payments to find the annual dividend growth rate. (If you have a quarterly pattern be sure to annualize this quarterly growth rate.) Now, find the required rate of return for this stock, assuming that the future dividend growth rate will remain the same and the company has an infinite horizon. Does this return seem reasonable for PepsiCo? Chapter 9 – Q10 10. Net present value. Lepton Industries has four potential projects, all with an initial cost of $1,500,000. The capital budget for the year will allow Lepton to accept only one of the four projects. Given the discount rates and the future cash flows of each project, determine which project Lepton should accept. ANSWER: Chapter 11 – Q12 12. Book value versus market value components. The CFO of DMI is trying to determine the company’s WACC. Brad, a promising MBA, says that the company should use book value to assign the components percentage for the WACC. Angela, a long-time employee and experienced financial analyst, says the company should use market value to assign the components. The after-tax cost of debt is at 7%, the cost of preferred stock is at 11%, and the cost of equity is at 14%. Calculate the WACC using both the book value and market value approaches with the following information. Which do you think is better? Why? Chapter 16 9. Finding the WACC. Monica is the CFO of Cooking for Friends (CFF) and uses the pecking order hypothesis (POH) philosophy when she raises capital for company projects. Currently, she can borrow up to $600,000 from her bank at a rate of 8.5%, float a bond for $1,100,000 at a rate of 9.25%, or issue additional stock for $1,300,000 at a cost of 17%. What is the WACC for CFF if Monica chooses to invest: a. $1,000,000 in new projects? b. $2,000,000 in new projects? c. $3,000,000 in new projects? 10. Finding the WACC. Chandler has been hired by Cooking for Friends to raise capital for the company. Chandler increases the funding available from the bank to $900,000, but with a new rate of 8.75%. Using the data in Problem 9, determine what the new weighted average cost of capital is for borrowing $1,000,000, $2,000,000, or $3,000,000 Prepare the DuPont analysis for each of the two companies you researched in Week 2. Develop a 350-word analysis of the following: • Compare the two company findings. • Analyze the research and calculations to determine in which company you would invest. Format the assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment.

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$7.00

This Tutorial was purchased 4 times & rated A by student like you.

This Tutorial contains 2 different Papers     Individual Assignment: Limited Liability Corporation and Partnership Paper Individual Assignment: Limited Liability Corporation ..
$50.00

This Tutorial was purchased 20 times & rated A by student like you.

FIN 419 Week 1 Business Structure and Financial Statements FIN 419 Week 2 Time Value of Money Calculations FIN 419 Week 3 Cash Conversion Cycle Analysis (CVS Health) FIN 419 Week 3 Cash Conversion Cycle Analysis (Samsung) FIN 419 Week 3 Cash Flow Estimation FIN 419 Week 4 Capital Bu..
$12.00

This Tutorial was purchased 14 times & rated A+ by student like you.

Ch 10 Advanced Problem 2 Chapter 13 Problem 18 Chapter 12 Problem 17 Ch 11 Advanced problem 1 ADVANCED PROBLEMS FOR SPREADSHEET APPLICATION These problems are available in MyFinanceLab. 1. Erosion costs. Ice Cream City plans to introduce a new flavor, wild berry, to its current set of five ..
$40.00

This Tutorial was purchased 3 times & rated A by student like you.

FIN 419 Week 1 Business Structure and Financial Statements FIN 419 Week 2 Time Value of Money Calculations FIN 419 Week 3 Cash Conversion Cycle Analysis (CVS Health) FIN 419 Week 3 Cash Conversion Cycle Analysis (Samsung) FIN 419 Week 3 Cash Flow Estimation FIN 419 Week 4 Capital Bu..
$20.00

This Tutorial was purchased 5 times & rated A by student like you.

FIN 419 FINAL EXAM NEW JUNE 2017 You want to invest in a stock that pays $6.00 annual cash dividends for the next five years. At the end of the five years you will sell the stock for $30.00. If you want to earn 10% on this investment what is a fair price for this stock if you buy it today? • $2..
$12.00

This Tutorial was purchased 7 times & rated A+ by student like you.

About Your Signature Assignment Signature/Benchmark Assignments are designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree...
$12.00

This Tutorial was purchased 5 times & rated A by student like you.

About Your Signature Assignment Signature/Benchmark Assignments are designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree...
$9.00

This Tutorial was purchased 4 times & rated A+ by student like you.

FIN 419 Week 4 Stock Valuation Assignment Steps Resources: Stock Valuation Template Calculate the following stock valuation problems: • Company X is paying an annual dividend of $1.35 and has decided to pay the same amount forever. How much should you pay for the stock, if you want to earn an ..
$9.00

This Tutorial was purchased 11 times & rated A by student like you.

FIN 419 Week 4 Capital Budgeting Decision Models Assignment Steps Resources: Microsoft® Excel®, Capital Budgeting Decision Models Template Calculate the following problems using Microsoft® Excel®: Calculate the NPV for each project and determine which project should be accepted. Proje..
$8.00

This Tutorial was purchased 2 times & rated B+ by student like you.

FIN 419 Week 3 Cash Flow Estimation Assignment Steps Create a 700-word summary explaining the importance of cash flow. Include the following: • How cash flow differs from profits. • The author of Financial Management mentions seven issues that have to be kept track of during a comprehensive ca..
$9.00

This Tutorial was purchased 4 times & rated A+ by student like you.

FIN 419 Week 3 Cash Conversion Cycle Analysis Assignment Steps Select a multinational company from the following industries: • Retail • Pharmaceutical • Computer Hardware • Manufacturing • Automotive Review the selected company’s most recent financial statements. Calculate the following c..
$9.00

This Tutorial was purchased 3 times & rated A by student like you.

FIN 419 Week 3 Cash Conversion Cycle Analysis Assignment Steps Select a multinational company from the following industries: • Retail • Pharmaceutical • Computer Hardware • Manufacturing • Automotive Review the selected company’s most recent financial statements. Calculate the following c..
$9.00

This Tutorial was purchased 2 times & rated B+ by student like you.

FIN 419 Week 2 Time Value of Money Calculations Assignment Steps Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template Calculate the following time value of money problems using Microsoft® Excel®: 1. If we place $8,592.00 in a s..
$9.00

This Tutorial was purchased 3 times & rated A by student like you.

FIN 419 Week 1 Business Structure and Financial Statements Assignment Steps Develop a 1,050-word evaluation describing business structure and financial statements, including the following: • Identify and describe the legal categories of a business organization contrasting tax-related advantages a..
fin419help © 2017 All Rights Reserved.Powered by:Webzindagi