Shopping Cart
Your shopping cart is empty!
FIN 419 Week 4 Team Assignment Problem Set (New)
$12.00

FIN 419 Week 4 Team Assignment Problem Set (New)

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

 

This Tutorial contains following Attachments

  • FIN 419 Week 4 Team Assignment Problem Sets (Another Set).docx

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 flavors, which include vanilla, French vanilla, strawberry, chocolate, and mint chocolate. The new sales of wild berry are projected as follows:

The expected sales will come from both new customers and current customers who switch flavors. The current projected sales for the existing flavors (assuming no introduction of the new flavor) are

Projected Sales

However, if the company introduces wild berry, it will cut into the sales of the original flavors based on the following estimates:

Percentage of Sales Erosion

Here are the revenue and cost per unit of ice cream for Ice Cream City:

Vanilla: current revenue of $3.05 per unit and cost of $1.22 per unit

French vanilla: current revenue of $3.15 per unit and cost of $1.38 per unit

Strawberry: current revenue of $3.25 per unit and cost of $1.41 per unit

Chocolate: current revenue of $3.25 per unit and cost of $1.57 per unit

Mint chocolate: current revenue of $3.25 per unit and cost of $1.63 per unit

Wild berry: projected revenue of $3.25 per unit and cost of $1.44 per unit

Find the annual erosion of revenue, the cost savings, and the net cash flow with the new ice cream.

 

Ch 11 Advanced problem 1

 

Changing WACC and optimal choice. Austin Enterprises is currently an all-equity firm. The firm is considering selling debt (bonds) and retiring some of the equity. However, at each level of debt, debt becomes more expensive (cost of debt is rising), and the riskiness of the equity also rises with more and more debt. Using a spreadsheet, determine the best combination of debt and equity for Austin Enterprises if

·         The current beta of Austin Enterprises is 0.85.

·         The current market return is 12%.

·         The current risk-free rate is 3%.

·         The total equity is 20,000,000 shares at $25 per share.

·         Debt is sold in units of $2,000,000.

·         The first unit of debt has a cost of 7.5%.

·         The tax rate of Austin Enterprises is 40%.

·         For each additional unit of debt (each additional $2,000,000), the cost of debt rises by 0.85%, and the beta of Austin Enterprises rises by 0.025.

Where is the WACC the lowest? Graph the results of the changing WACC

Chapter 12 Problem 17

Working capital and capital budgeting. Farbuck’s Tea Shops is thinking about opening another tea shop. The incremental cash flow for the first five years is as follows:

·         Initial capital cost = $3,500,000 Operating cash flow for each year = $1,000,000 Recovery of capital assets after five years = $250,000

The hurdle rate for this project is 12%. If the initial cost of working capital is $500,000 for items such as teapots, teacups, saucers, and napkins, should Farbuck’s open this new shop if it will be in business for only five years? What is the most it can invest in working capital and still have a positive net present value?

 

Chapter 13 Problem 18

Working capital and capital budgeting. Working capital investment is 25% of the anticipated first year sales for Wally’s Waffle House. The first-year sales are currently projected at $4,300,000. The incremental cash flow (not including working capital investment) is

·         Initial cash flow = $13,700,000 outflow Cash flow years 1 through 10 = $2,850,000

What is the internal rate of return of the ten-year project with working capital factored into the cash flow? What is the net present value at a 15% weighted average cost of capital? What is the maximum investment in working capital for an acceptable project with a 15% weighted average cost of capital?

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
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

What would be the constraints specifically dealing with different currencies and market rate fluctuations? ..
$3.00

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

What is a multinational corporation?  What are some of the constraints facing today’s multinational corporations?  Predict how joint ventures and international mergers might address some of those constraints.   ..
$3.00

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

What would you consider to be a global equivalent(s) to the SEC within the USA?   Are there individual reporting requirements comparable?  Explain?   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is the SEC?  How does it impact financial decision-making?  What constraints might it put on a company?     ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is EBIT-EPS analysis?  What is the indifference curve?  How is risk factored into the EBIT-EPS analysis?  What are the “basic short comings” of EBIT’s analyses?   ..
$3.00

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

What are the risks of having an excessive amount of financial leverage in an organization?  What is the degree of total leverage?   ..
$3.00

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

What is investment banking?  How would the investment banker assist an organization in going public?  As a CFO, what information would you need to select an investment banker?    ..
$3.00

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

What is the difference between operating and financial leverage?  What is the importance of assessing operating vs. financial leverage?   ..
$3.00

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

What is an asset?  What is a liability?  What is the difference between assets and liabilities?  Can an organization operate without current liabilities? Explain   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is zero working capital? How would you define zero working capital?  When would this methodology be used?  Would this model be applicable to all organizations? Explain.   ..
$3.00

This Tutorial was purchased 1 times & rated No rating by student like you.

How would the intrinsic value of assets differ from the market value? Explain. ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What is the difference between present values and future values?  How would you use present and future value techniques in preparing a financial plan for retirement?  How would various required rates of return affect your decision? Explain.   ..
$3.00

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

What is a loan amortization schedule?  How would you use it determine your loan interest rate?  What factors would impact your choice between two loans?   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What are the three key inputs to the valuation model?  How would you determine the valuation of an asset? How would the intrinsic value of assets differ from the market value? Explain.   ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

What are some risk management techniques?  How would you use portfolio management to assess the risk and return of an investment?    Predict how the results would be different based on different risk preferences?   ..
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

Based on your assessment of risk using portfolio Management, what factors would you use to make different risk preferences? ..
$3.00

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

What is a limited liability corporation? What is a limited liability partnership?    What are the differences?  What are the advantages and disadvantages of each?   ..
$3.00

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

What is a sensitivity analysis?  What is a scenario analysis?  How would you apply each one to a potential investment opportunity?  How would you use the information from this analysis? Explain.    ..
$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 and Partnership Paper   • Resources: Week One readings • Write a 700-..
$9.00

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

P9-7 Net present value. Quark Industries has a project with the following projected cash​ flows:     a.  Using a discount rate of 9​% for this project and the NPV​ model, determine whether the compan..
$9.00

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

This Tutorial contains excel sheet   P10-4 (similar to)               Opportunity cost. ​ Richardses' Tree​ Farm, Inc. has ..
$9.00

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

This Tutorial comes with a excel sheet   P3-1 Future Value.   Fill in the future values for the following table using one of  the three methods below: a.       Use the future value formula, FV = PV*(1+r)n. b.   &..
$9.00

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

This Tutorial contains excel sheet     P 11-1 Eric has another​ get-rich-quick idea, but needs funding to support it. He chooses an​ all-debt funding scenario. He will borrow $3683 from​ Wendy, who will charge him 7% on the loan. He will also borrow ​$3165 from​&nb..
$15.00

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

) Risk and probability Micro-pub, Inc., is considering the purchase of one of two microfilm cameras, R and S. Both should provide benefits over a10-year period, and each requires an initial investment of $4,000. Management has constructed the following table of elements of rates of return and pos..
$8.00

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

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..
$9.00

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

Read the "Mini-Case Biocom, Inc.: Part 2, Evaluating a New Product Line" from the end of Chapter 10 of Financial Management: Core Concepts. Complete questions 1-7 in Microsoft® Excel. Evaluate the following in a 350-word response: Explain what depreciation, cas..
$7.00

This Tutorial was purchased 0 times & rated No rating by student like you.

This Tutorial contains 2 Papers   Research two companies' financial statements from one of the following industries: Airline Automotive Pharmaceutical Oil/gas Retail Computer Hardware Analyze table 14.8 in Financial Managemen..
$9.00

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

Complete the following problem sets in Financial Management using Microsoft® Excel®: Chapter 2: 1, 2, 3, 4 Chapter 5: 1, 3, 5, 7 Chapter 5: Advanced Problems 1a and 1b Chapter 14: 9, 10, 11, 12 Format your assignment consistent with AP..
$9.00

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

Review the "Richardses' Tree Farm Grows Up - Mini Case" located in Chapter 1 of Financial Management: Core Concepts. Develop a 1,050-word analysis of the case study. Include the following: Analyze whether the major financial management decisions of the Richards..
$8.00

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

With Excel File (This Tutorial contains excel file to solve question for any values)   P18-1 Foreign exchange and commodity prices.  While traveling in the following​ countries, you see​ twenty-ounce plastic bottles of​ Coca-Cola. You know the price in the United S..
$15.00

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

ICS Manufacturing Company Case Study   ICS Manufacturing Company produces plastic parts for the automotive industry.  Here is their Income Statement for 2015 –   ICS Manufacturing Company Income Statement for 2015        &nb..
$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..
$20.00

This Tutorial was purchased 6 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..
$12.00

This Tutorial was purchased 4 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 th..
$12.00

This Tutorial was purchased 4 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 th..
$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..
$9.00

This Tutorial was purchased 3 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 p..
$8.00

This Tutorial was purchased 2 times & rated A 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 du..
$9.00

This Tutorial was purchased 5 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 stateme..
$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 stateme..
$9.00

This Tutorial was purchased 3 times & rated A 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 pl..
$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 ..
$50.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 Budgeting Decisi..
Fin419Assist © 2017 All Rights Reserved.Powered by:Webzindagi.