Estimate variable and fixed cost for publicly traded company

Assignment Help Business Management
Reference no: EM132054020

Case 1: Purchase Point Media Corporation (PPMC)

INTRODUCTION
This case is based on actual financial projections developed and provided by a publicly traded firm, Purchase Point Media Corporation (PPMC). Carefully examine the PPMC projections, which are presented in a sequence and format suitable for break-even calculation and analysis. After you calculate the break-even point, use additional, publicly available informa- tion to come to a decision with respect to market potential.

The increase in the price per share of PPMC stock suggests that, over time, the market may have reacted to their results and analyses, using a comparable methodology.

OBJECTIVES

When you complete this case, you'll be able to
- Identify discernable errors, irregularities, and impropri- eties in style and format within publicly reported data
- Meet financial statement presentation requirements for a specific "real world" example
- Determine whether financial information provided follows generally accepted accounting principles (GAAP) or is presented in "good form"
- Distinguish between the substance and form of financial statements
- Estimate variable and fixed costs for a publicly traded company
- Assess publicly disseminated information from publicly traded companies to determine the feasibility of market potential and market penetration
- Exercise enhanced critical-thinking skills

CASE BACKGROUND
Purchase Point Media Corporation (Pink Sheets: PPMC) is what some refer to as a thinly traded "corporate shell." The firm held patents in the United States, Canada, United Kingdom, and Germany for a shopping-cart display device, but was a nonreporting and nonoperating entity.

On March 18, 2002, PPMC reported its intention to sell these patents and related trademarks. The initial estimates sug- gested a stock price of nearly $2.50 per share, before related per-share deductions for sale-related broker's commissions and legal fees. At the time of the news release, the firm's stock was trading at $0.04 per share. In less than 60 days the stock was trading at more than $0.60 per share (Cataldo 2003, 55-60), for a 1,400 percent increase in price per share. (Note that investors and speculators alike would view this as a very risky investment, and the price per share for PPMC stock would be expected to fall short of or sell at a significant discount to the "anticipated" selling price for the firm's intan- gible assets. See Arbel and Strebel 1982 and 1983; Arbel, Carvell and Strebel 1983; and Arbel 1985 for guidance on thinly traded or "neglected" firms.)

While this initial news release attracted speculators, causing the stock price to rise, after months without any additional news releases, the stock price drifted down again. On August 20, 2003, PPMC again announced its intention to sell the firm's intangible assets (Business Wire 2003).

In the second announcement, PPMC management referred interested investors to their corporate Web site. Among the data provided, PPMC included a financial projection and other items they felt might be of interest to potential pur- chasers of the firm's intangible assets (see Exhibit 1, Purchase Point Media Corp. statement, which follows).

To begin this case, review and comment on the "form" of the public disclosure circulated by PPMC. Then use the "substance" of this information to develop per-unit, sales- based contribution margins and break-even points for the first year of operations. Last, gather other publicly available information to determine the market feasibility of achieving its break-even point.

PROJECT REQUIREMENTS
The project requires three steps to be presented. Step 1 - Identify Form and Substance Errors.
Step 2 - Compute the Purchase Point Media (PPMC) break-even points in terms of carts and stores.
Step 3 - Determine the number of grocery stores for various food chains.
In one Word document, provide individual sections for each Step. This Word document along with the Excel file
(described below for Step 2) will be uploaded when you click on the Take Exam button on your Student Portal to submit your project (described under the "Submitting Your Assignment" later in the instructions).
This Senior Capstone project highlights your knowledge and the skills you have developed over the course of your education. There is nothing "new" to be learned here.

The knowledge and skills required for this project include English Composition, Financial Accounting, Managerial Accounting, Information Literacy and the abilities to think critically, do research and to present your work in a professional manner.

If you are unsure or don't understand something about the project, then go back to your previous subjects to review.

For example, if you don't remember how to make a proper citation, then revisit your English Composition to see how to make a correct citation. Or, if you don't remember how to calculate a break-even point, go back to Managerial Accounting and review the subject matter pertaining to that concept.

Remember, there is nothing "new" here. Everything about this project you should already know how to do.

Case 2: Motomart

INTRODUCTION

The Motomart case is designed to supplement your Managerial/ Cost Accounting textbook coverage of cost behavior and variable costing using real-world cost data and an auto-industry- accepted cost driver. Unlike textbook problems, this data is real. It won't necessarily produce a clear solution when you attempt to analyze cost behavior and apply scatter-plot, high-low, and regression methods to separate mixed costs into their fixed and variable components. This case also illustrates that Financial Accounting decisions and methods can have an influence on Cost Accounting and Managerial applications and decisions.

OBJECTIVES
When you complete this case, you'll be able to
- Explain the importance of accrual accounting and proper application of the matching principle for the computation of contribution margins and break-even points
- Apply knowledge of generally accepted accounting principles (GAAP) to a specific real-world example
- Integrate statistical analyses and scatter plots, line graphs, and regression to determine the reliability of financial information prepared for external use
- Use analytical review procedures to examine a firm's financial statements
- Apply critical-thinking skills to real-world business circumstances

CASE BACKGROUND
This case is based on real financial data provided by a retail automobile dealership (Motomart) seeking to relocate closer to an existing retail dealership. You'll examine the mixed cost data from Motomart and apply both high-low and regression to attempt to separate mixed costs into their fixed and variable components for break-even and contribution margin compu- tations. You'll find that the data is flawed because Motomart was a single observation in a larger database. Don't attempt to correct the data (e.g., remove outliers or influential outliers).

You'll be producing a scatterplot and apply high-low and regression methods to the extent practicable and writing a summary report of the findings.

Motomart operates a retail automobile dealership. The manufacturer of Motomart products, like all automobile manufacturers, produces forecasts. It has long been an industry practice to use variable costing-based/break-even analyses as the foundation for these forecasts, to examine their cost behavior as it relates to the new retail vehicles sold (NRVS) cost driver. In preparing this financial information, a common financial statement format and accounting proce- dures manual is provided to each retail auto dealership.

The dealership is required to produce monthly financial statements using the guidelines provided by this common accounting procedures manual, and then furnish these financial statements to the manufacturer. General Motors, Ford, Nissan, and all other automobile manufacturers employ similar procedures manuals.

The use of a common format facilitates the development of composite financial statements that can be used to estimate costs and produce financial forecasts for future or proposed retail dealership sites (Cataldo and Kruck 1998). Zimmerman (2003) suggests that as many as 77 percent of manufacturers divide costs into variable and fixed components, and that managers arrive at these estimates by classifying individual accounts as being primarily fixed or primarily variable (67).

For this case, you'll examine mixed costs as defined by the manufacturer. Using the scatterplot, high-low, and regression methods, separate these mixed costs into their fixed and variable components. The data is problematic, and a clear solution won't exist. Don't attempt to correct the data by removing outliers, but make observations based on any pat- terns you observe. The case will expose you to actual data and require you to summarize your findings, including any conclusions you're able to reach and why the financial data makes it impossible to separate the mixed costs into their fixed and variable components.

REQUIREMENTS
The project requires five steps to be presented.
Step 1 - Provide comments on a 5 year Income Statement. Step 2 - Discuss patterns in expense items.
Step 3 - Identify High/Low activity levels. Step 4 - Compute cost equations.
Step 5 - Summarize your findings.

In one Word document, provide individual sections for each Step. This Word document along with the Excel file (described below) will be uploaded when you click on the Take Exam button on your Student Portal to submit your project (described under "Submitting Your Assignment" later in the instructions).

This Senior Capstone project highlights your knowledge and the skills you have developed over the course of your educa- tion. There is nothing "new" to be learned here.

The knowledge and skills required for this project include English Composition, Financial Accounting, Managerial Accounting, Business Statistics and the abilities to think crit- ically and to present your work in a professional manner.

If you are unsure or don't understand something about the project, then go back to your previous subjects to review. For example, if you don't remember how to use the High/Low Method, the revisit your Managerial Accounting to refresh your memory on how to use the High/Low Method

Remember, there is nothing "new" here. Everything about this project you should already know how to do.

On your Student Portal, under the Supplements section of the Senior Capstone subject is a downloadable Excel file titled "Exam 500896 - Motomart Excel Spreadsheet".

• The Excel file provides a detailed example of what needs to be done for one of the expenses in order to fill out the figures required in Steps 3 & 4. You will include this Excel file as part of your project submission along with the Word document you create to present this project.
o There is a "60 Months" worksheet that has the 60 months of data already entered. There is also a "Sample" worksheet that an example of how to cal- culate the R-sq.
o There is a "PLOT - SALARY" worksheet that shows how the FC, VC and R-sq figures are calculated for Salary.
o There is also a "high&low" worksheet for help with the high/low method in Step 3.
o Complete and include the Excel spreadsheet. You will need to create new worksheets for each of the other expenses following the example to calculate the figures needed for Table 5.

Attachment:- Senior Capstone.rar

Verified Expert

Purchase Point Media Corporation (PPMC) is the sole mediator of various grocery chains in the US. Enron on the other hand is known for its energy and commodities services in New York while Motomart is one of the leading grocery stores in the Hong Kong. Motomart had a substantial increase in revenue over a span of five years but the organization suffered heavy losses due to high salary allocation and very limited customer reach. The organization spent huge amounts on advertising but did not receive enough customers due to high price of products.

Reference no: EM132054020

Questions Cloud

What is the financial break-even quantity : What is the financial break-even quantity? Calculate the net present value of the project.
Calculate the exact npv of this project : What is the cash flow in year 3 and 4 given APR is 10%? Can you calculate the exact NPV of this project using only the given information?
Analyze the collected data from a program evaluation : What does it mean to analyze the collected data from a program evaluation? An analysis involves reviewing multiple components, such as analyzing.
What is the present value of perpetuity : If his stated annual interest rate is 17% compounded monthly, what is the present value of this perpetuity?
Estimate variable and fixed cost for publicly traded company : Identify discernable errors, irregularities, and impropri- eties in style and format within publicly reported data
Explain the principal assumptions used in the ddm valuation : FINC 440 : Explain the principal assumptions used in the DDM valuation? Are the valuations consistent - why or why not?
Examine the impact of the iom report on nursing education : Review the Institute of Medicine (IOM) report: "The Future of Nursing: Leading Change, Advancing Health," focusing on the following sections.
Write a response on The New Momism : Write a response on any one of the reading (s) that most spoke to you. Relate them to your own life experience, Reading - "The New Momism"
What is his expected lifetime professional earnings : What is his expected lifetime professional earnings if he stays an additional year at college?

Reviews

inf2054020

8/27/2018 3:20:28 AM

The report justify the topic. 1. The location of the error. 2. What the error is. 3. How the text should have been written correctly. Summary of marking grades in the Form of the PPMC Report 1. Location: The first page of Exhibit 1, the last sentence of the first paragraph states “You should independently investigate and fully understand all risk before making investment decisions.” Thanks Expert Mind for the accurate and detailed solution which you have provided me.

inf2054020

8/27/2018 3:15:50 AM

I got good markings on the paper. The instructor seems happy about the paper.The instructions for the paper are followed. The PPMC report, focusing on problems with the form of the report. (“Form” means spelling, punctuation, and capitalization are correct and that the text is grammatically correct. Also, form means that the format of the text as far as font, bold, underlining, indents, and so on are correct.) Prepare a typed, clearly communicated summary of all errors or weaknesses you find in the form of this report. This is a numbered list. Although the PPMC report is well-written

inf2054020

8/9/2018 2:03:51 AM

The instructions clearly state that the errors in grammar, punctuation, calculations and so on need to be specified and corrected. so please take care of it and read instructions carefully and send solution accordingly.

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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