Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

So, suppose we begin with the default conditions for Quarter #1 (in the manual). We might want to know what to expect for Quarter #2.

image text in transcribedSo, suppose we begin with the default conditions for Quarter #1 (in the manual). We might want to know what to expect for Quarter #2. So, assume (your inputs) as follows: What would we expect the outputs for Quarter #2 to be?

Pro Forma Decision Inputs for Quarter Number 2

Units Demanded 103,000

Short-term investment rate 1% per quarter

Short-term loans rate 1.5% per quarter

Two-year loans rate 2% per quarter

Three year loan rate 2.5% per quarter

Long-term loan rate 3% per quarter

Preferred stock yield 3.5% per quarter

Capital gains rate NA

Company Operating Decisions: Pro Forma

Units to be produced 98,000

Per unit price $101

Div. per common share $0.15

Advertising cost 0

Demand/price forecast 0

Sales discount 0

Investment Decisions: Pro Forma

Short-term investment$2,500,000

Risk of S-T investment 0

Machine units bought 0

Units of plant bought 0

Project A no

Project B no

Financing Decisions: Pro Forma

Short-term loans 0

Preferred shares 0

Two-year loans $3,000,000

Common shares 0

Three-year loans 0

Common tender price 0

Ten-year bonds 0

Special Options: Pro Forma NA

Strike settlement (per hr.) NA

Dollar penalty NA

So what should we expect?

Please Fill in the blanks.This document will be sent as a Word file so you can add lines as needed. Include both a number and how you got it. For example, if we have sales of 103,000 units at a price of $101, we would expect $10,403,000 in sales because 103,000 times $101 is $10,403.000.Please fill in the blanks.

Pro Forma Performance Report

Quarter Number 2

Sales revenue ( 103,000 units at $101.00 ) $10,403,000 (unit sales * price)

Income from securities _____ (funds invested * interest rate)

Total revenue _____ ...

Cost of Goods Sold:

Beginning Inventory:

In units _____ ...

In cost per unit _____ ...

Value of _____ ...

Materials (costs) _____ ...

Direct Labor (costs) _____ ...

Total Direct Costs _____ ...

Warehousing Costs _____ ...

Depreciation: Mach. and Equip. _____ ...

Plant _____ ...

EXHIBIT4.1 Sales Revenue (97,383 units at 100.00) Income from Securities Cost of Goods Sold: Beginning Inventory: (9,809 at $74.79) Materials Direct Labor Total Direct Costs Warehousing Costs Depreciation: Mach. and Equip. Plant Other Overhead Costs Total Indirect Costs Production Costs (100,000 at $70.39) Goods Available for Sale (70.78 per unit) Less: Ending Inventory (12,426 units) Cost of Goods Sold Gross Profit Selling and Administrative Expenses Financial Expenses: Short-Term Bank Interest Penalty-Loan Interest Intermediate-Term Loan Interest Bond Interest Bond Redemption Costs Total Financial Charges Operating Income before Extraordinary Items Extraordinary Items Income before Taxes Income Tax (rate is 40% ) Income after Taxes Preferred Stock Dividend Earnings to Common Stockholders Common Stock Dividends (\$0.10 per share) Net Income Transferred to Retained Earnings Company Name Quarterly Performance Report Quarter 1 $9,738,300 $9,741,025 \$ 733,567 2,038,533 7,038.5337,772,100879,492 $2,848,4176,892,608 $0092,74933,6000 126.349 $1,235,1531,613,264 $1,235,153494,060$741,093 \begin{tabular}{rr} & 0 \\ \hline$741,093 \\ 100,000 \\ $641,093 \\ \hline \end{tabular} EXHIBIT4.1 Sales Revenue (97,383 units at 100.00) Income from Securities Cost of Goods Sold: Beginning Inventory: (9,809 at $74.79) Materials Direct Labor Total Direct Costs Warehousing Costs Depreciation: Mach. and Equip. Plant Other Overhead Costs Total Indirect Costs Production Costs (100,000 at $70.39) Goods Available for Sale (70.78 per unit) Less: Ending Inventory (12,426 units) Cost of Goods Sold Gross Profit Selling and Administrative Expenses Financial Expenses: Short-Term Bank Interest Penalty-Loan Interest Intermediate-Term Loan Interest Bond Interest Bond Redemption Costs Total Financial Charges Operating Income before Extraordinary Items Extraordinary Items Income before Taxes Income Tax (rate is 40% ) Income after Taxes Preferred Stock Dividend Earnings to Common Stockholders Common Stock Dividends (\$0.10 per share) Net Income Transferred to Retained Earnings Company Name Quarterly Performance Report Quarter 1 $9,738,300 $9,741,025 \$ 733,567 2,038,533 7,038.5337,772,100879,492 $2,848,4176,892,608 $0092,74933,6000 126.349 $1,235,1531,613,264 $1,235,153494,060$741,093 \begin{tabular}{rr} & 0 \\ \hline$741,093 \\ 100,000 \\ $641,093 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Euro A Challenge And Opportunity For Financial Markets Routledge International Studies In Money And Banking

Authors: Michael Artis , Elizabeth Hennessy, Axel Weber

1st Edition

0415217105, 978-0415217101

More Books

Students also viewed these Finance questions

Question

Evaluate three pros and three cons of e-prescribing

Answered: 1 week ago