Purchase Solution

Income statement, rate increases

Not what you're looking for?

Ask Custom Question

Could someone help me with this. I have half done but got confussed. Please see the attached document. Thanks!
The questions are as follows:

1) Prepare a projected income statement for Metropolitan News for the 20X3-X4 fiscal year using a format that shows the total variable costs and total fixed costs for the newspaper (round calculations the nearest thousand dollars).
2) The management of Metropolitan News is contemplating one additional proposal for the 20X3-X4 fiscal year-raising the for the newspaper to the following amounts:

Single issue price: $0.20 daily; $0.40 Sunday
Weekly subscription: $1.25 (includes daily and Sunday)

The company estimates that the newspaper's circulation would decline to 90 percent of the currently anticipated 20X3-X4 level for both newsstand and home delivery sales if this change is initiated. Calculate the effect on the projected 20X3-X4 income if this proposed rate increase is implemented.

Purchase this Solution

Solution Summary

The expert analyzes income statement and rate increase functions.

Solution Preview

I have structured my answer in two parts.
The first part in this email, in which I will give you general instruction on how to handle this type of problems and on how to handle this problem specifically.
The second part is the excell spreadsheet to which I will refer during the first part. The excel spreadsheet is not your final answer, it should be used as a descriptive tool to get to your answers. All the formulas and results are shown but the format of the answer and the figures are not the ones that you've been asked for (I use a different version of Excel).
In the spreadsheet you have three tabs. 2003 which is what you had in the word document. 2004 (1) which contains the details of the answers to question 1 and 2004 (2) which is a copy of 2004 (1) with the changed parameters (see below) to answer question 2.

Part 1

a) General instructions for this type of problems
In this type of problem, you are requiered to build a model (question 1) to which you can change some input parameters (question 2). Therefore what you need to do while answering the first question is to single ...

Purchase this Solution

Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Introduction to Finance

This quiz test introductory finance topics.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.