FIN 419 Week 2 Team Problem Set
$9.00

FIN 419 Week 2 Team Problem Set

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

 

This Tutorial contains following Attachments

  • FIN 419 N Week 2 Team Problem Set.xlsx

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 APA guidelines. Click the Assignment Files tab to submit your assignment. Chapter 2: Problem 1 1. Balance sheet. From the following balance sheet accounts, a. construct a balance sheet for 2013 and 2014. b. list all the working capital accounts. c. find the net working capital for the years ending 2013 and 2014. d. calculate the change in net working capital for the year 2014. Chapter 2: Problem 2 2. Income statement. From the following income statement accounts, a. produce the income statement for the year b. produce the operating cash flow for the year Chapter 2: Problem 3 3. Balance sheet. From the following balance sheet accounts, a. construct a balance sheet for 2013 and 2014 b. list all the working capital accounts c. find the net working capital for the years ending 2013 and 2014 d. calculate the change in net working capital for the year 2014 Chapter 2: Problem 4 4. Income statement. From the following income statement accounts, a. produce the income statement for the year Chapter 5: Problem 3 3. EAR. What is the EAR of a mortgage that is advertised at 7.75% (APR) over the next twenty years and paid with monthly payments? Chapter 5: Problem 5 5. Present value with periodic rates. Let’s follow up with Sam Hinds, the dentist, and his remodeling project (Chapter 4, Problem 12). The cost of the equipment for the project is $18,000, and he will finance the purchase with a 7.5% loan over six years. Originally, the loan called for annual payments. Redo the payments based on quarterly payments (four per year) and monthly payments (twelve per year). Compare the annual cash outflows of the two payments. Why does the monthly payment plan have less total cash outflow each year? Original Problem from Chapter 4, Problem 12 to go with Chapter 5 Problem 5: 12. Payments. Sam Hinds, a local dentist, is going to remodel the dental reception area and add two new workstations. He has contacted A-Dec, and the new equipment and cabinetry will cost $18,000. A-Dec will finance the equipment purchase at 7.5% over a six-year period. What will Hinds have to pay in annual payments for this equipment? Chapter 5: Problem 7 7. Future value with periodic rates. Matt Johnson delivers newspapers and is putting away $15.00 every month from his paper route collections. Matt is eight years old and will use the money when he goes to college in ten years. What will be the value of Matt’s account in ten years with his monthly payments if he is earning 6% (APR), 8% (APR), or 12% (APR)? Chapter 5: Advanced Problem 1a & 1b 1. Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a loan for the whole amount for the condo for twenty years at 7.0% interest. a. What is the monthly payment on the mortgage? Construct the amortization of the loan for the twenty years in a spreadsheet to show the interest cost, the principal reduction, and the ending balance each month. b. Then change the amortization to reflect that after ten years, Sherry and Sam will increase their monthly payment to $7,500 per month. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal? Chapter 14: Problems 9, 10, 11 & 12 listed below: 9. Financial ratios: Liquidity. Calculate the current ratio, quick ratio, and cash ratio for Tyler Toys for 2013 and 2014. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the shareholders? 10. Financial ratios: Financial leverage. Calculate the debt ratio, times interest earned ratio, and cash coverage ratio for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the shareholders? 11. Financial ratios: Asset management. Calculate the inventory turnover, days’ sales in inventory, receivables turnover, days’ sales in receivables, and total asset turnover for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the shareholders? 12. Financial ratios: Profitability. Calculate the profit margin, return on assets, and return on equity for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the shareholders?

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 1 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 3 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 3 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 3 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 4 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 5 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 6 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 4 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 2 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 3 times & rated B+ 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 3 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 3 times & rated B+ 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 No rating 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 3 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 ..
$9.00

This Tutorial was purchased 27 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. Use the TVM keys from a calculor. c. Use the TVM function in a spreadsheet. P3 – 4 Futur..
$9.00

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

This Tutorial contains excel sheet P10-4 (similar to) Opportunity cost. Richardses' Tree Farm, Inc. has branched into gardening over the years and is now considering adding patio furniture to its product lineup. Currently, the area where the patio furniture is to be displayed is a vacant ..
$9.00

This Tutorial was purchased 14 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 company should accept or reject this project. b.  Should the company accept or reject it using a discoun..
$15.00

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

1) 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&n..
$50.00

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

This Tutorial was purchased 16 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, cash flow, operating cash flow and NP..
$7.00

This Tutorial was purchased 8 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 Management: Core Concepts, Ch. 14: "Financial Ratios: Industry A..
$9.00

This Tutorial was purchased 13 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 family involve capital budgeting,..
$8.00

This Tutorial was purchased 13 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 States for a Coke is $0.990.99, b..
$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 Sales Revenue $35,500,000 Cost of Goods Sold 12,725,000 Sellin..
$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 8 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 10 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 9 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 16 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 5 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 during a comprehensive ca..
$9.00

This Tutorial was purchased 8 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 15 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 9 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 place $8,592.00 in a s..
$9.00

This Tutorial was purchased 8 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