Purchase Solution

Income statement, rate increases

Not what you're looking for?

Ask Custom Question

Hello,
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.

Attachments
Purchase this Solution
Solution Summary

The expert analyzes income statement and rate increase functions.

Solution Preview

Hello
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.

View More Free Quizzes
Related BrainMass Solutions

  • COST STRUCTURE; BREAK-EVEN POINT; TARGET PROFITS

    The sales agents are currently paid an 18% commission on sales, and this commission rate was used when Hard Rock's management prepared the following budgeted income statement for the upcoming year.

  • Income Statements, Sustainable Growth Rate

    503893 Income Statements, Sustainable Growth Rate, and Table of Interest Rates 5.

  • Pro Forma income statement and determine break even point

    431643 Pro Forma Income Statement Using Excel, create a three year Pro Forma income statement and determine break even point on the data attached. Based on the organization you have created a.

  • Income Tax Expense, Investment Revenue, and Tax Liabilities

    For example, revenues or gains reported on the tax return after the income statement; expenses reported on the tax return before the income statement.

  • Question about Proforma Income Statement

    We first make the current income statement Current Forecast Sales 3,000 3,300 Sales Increase by 10% Operating costs excluding depreciation 2,450 2,640 These are 80% of sales EBITDA 550 660 Depreciation 250 275 Increases by

  • Partnership and Corporate Taxation

    Trout pays tax on $0 income, Glens taxable income increases by $140,000, and Michaels taxable income increases by $140,000, is correct. 2. This statement is true.

  • Depreciation and capital budgeting

    For example Earnings before depreciation and tax are $10,000 Depreciation is 5,000 Tax rate is 40% If depreciation is not included then EBIT = 10,000 Tax = 4,000 Net Income = 6,000 which is the cash flow If depreciation is included EBIT

  • Theoretical and Practical Aspects of Financial Management

    Describe the statement of cash flows and why it is important to financial decision making. 2. Contrast the information provided in the balance sheet and income statement. 3.

  • Unit Product Cost Analysis

    in income statement; cogs reduces finished goods inventory J: Indicates that over/under applied should adjust COGS on income statement Click on cells to see formulas. ------------- I assume that the amounts were in thousands so that they matched

  • Variable costing/Absorption costing/Breakeven

    Prepare an absorption-costing income statement. 4. Prepare a variable-costing income statement. 5. Reconcile the differences in income that you calculated in #3 and #4 . 6. Calculate the breakeven point in units. 7.

View More Related Solutions