Perform a payback period analysis Excel file

Assignment Help Accounting Basics
Reference no: EM132631902

Question - You are the controller of Wolf Media Corp. (Wolf), a publicly owned Canadian company. Wolf's operations include television production, live theater production, and interactive media. The company built its reputation on providing high-quality, educational, family entertainment showcasing multiple languages and cultures. The company has total assets of $110 million, but due to the recent economic downturn, Wolf's share price has been falling. This is concerning, as the company plans on doing a new share offering in the near future. It is hoped that its recent signing of a new musical production, Dragon Dreams, will help turn things around.

One of the members of Wolf's Board of Director's saw the world-famous family musical show Dragon Dreams in London, England, last year. He put Wolf's theatrical production division general manager, John Narle, in touch with Dragon Dreams' producer, and a deal was quickly signed giving Wolf full Canadian licensing rights to the production for the next five years. While the show ran for three years in England and achieved a four out of five star critic and press rating, Wolf management would be happy to see the production last for two years in Canada. Wolf's share price increased by 10% as soon as the deal was announced.

The production is still six months away from being completed and Wolf started selling tickets two months ago. The tickets are refundable only if the production is cancelled. The first 10 weeks of the show's run are completely sold out. Average ticket prices are $65, the theater used for the production has 1,000 seats, and the show will run seven nights a week. As at December 31, 2019, the company had invested $12 million in pre-production costs. The company expects to spend another $1.5 million prior to opening night and will incur weekly production costs of $425,000 once the show opens. Advertising is budgeted to be $1.2 million annually.

It is now one month after the company's year end. You are preparing for the monthly meeting of the board of directors. You know that the board is expecting an analysis of Dragon Dreams and wants to know whether Wolf should still proceed with the show. Some board members are starting to worry that it is too high a risk. The board is also very interested in designing financial and non-financial performance measures to evaluate the performance of the theatrical production division and its general manager.

Required - Prepare the relevant information for the board. Perform a payback period analysis Excel file.

Reference no: EM132631902

Questions Cloud

Real interest rate during period : The nominal interest rate during this period was 4.5 percent. What was the real interest rate during this period?
Prepare contribution format segmented income statements : Prepare contribution format segmented income statements for the Northern Territory broken down by product line. (Round the percentage answers)
Describe the important term metastructure : Choose an important informatics term, such as metastructure (e.g., data, information, knowledge, and wisdom), concept (e.g., design or structure), or tool.
Identify symptoms of organizational behavior problem : Identify the symptoms of the organizational behavior problem you have observed.
Perform a payback period analysis Excel file : Wolf's operations include television production, live theater production, and interactive media. Perform a payback period analysis Excel file
What is average annual growth rate of real gdp : If the price index was 100 in 2010 ( based year) and 220 in 2018, and nominal GDP was 160$ billion in 2010 and real GDP
Describe the medication you wish to explore : Describe the medication you wish to explore. Identify your purpose: Why are you interested in this particular medication? (1-2 paragraphs)
Direction the value of the multiplier : Explain why and in what direction the value of "the" multiplier will change if consumption and investment demand
What are the budgeted cash disbursements for June : The company has a policy of paying for 50% of the purchases in the month of purchase, what are the budgeted cash disbursements for June

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd