Solution-Prepare a sheet for income statement and cash flow

Prepare a sheet for income statement and cash flow statement

Reference no: EM13852665

I need help doing an income statement (Part A) and cash flow statement (Part B) showing relevant subtotals in Excel. The answer can be in Excel or a Word document that I will transfer to Excel so long as the formulas are explained step-by-step. I have attached the assignment and course reading for additional information.

PART A

Prepare a formal income statement that contains the relevant subtotals. Show values in whole dollars (no cents).
Data Block		Amount
	Cash (Beginning of year)	$503,500
	Quantity Sold	35,200
	Quantity Produced	63,000
	Sales Price	$45.00
	Cost per unit to produce	$25.40
	Staff Expenses	$426,400
	Facility Expenses	$278,200
	Asset Sale	$1,755,300
	Asset Purchase	$2,205,000
	Tax rate	25%
	Depreciation	$28,000
	Interest Paid on Loan	$63,000
	Loan Principle payment	$152,000
	Dividends	$108,000

PART B

Assignment Week 05					Score
Prepare a cash flow statement using the following data. Assume that no taxes are due on asset purchases or sales. Prepare a formal cash flow statement that contains the relevant subtotals. Show values in whole dollars (no cents). Indicate the ending cash balance.
Data Block		Amount
	Cash (Beginning of year)	$360,600
	Net Income	$598,000
	Staff Expenses	$764,200
	Facility Expenses	$887,200
	Asset Sale	$156,530
	Asset Purchase	$1,240,400
	Tax rate	22.5%
	Depreciation	$89,500
	Interest Paid on Loan	$76,000
	Loan Principle payment	$50,000
	New Loan	$500,000
	Dividends Paid	$100,000


	Working Capital Worksheet
		Beginning	Ending	Change
	Inventory	$84,000	$87,000
	Accounts Receivable	$78,000	$73,000
	Accounts Payable	($75,000)	($78,000)
			Total

Reference no: EM13852665

Questions Cloud

What are the near-term prospects for the us economy : A friend of yours has just returned from desert island where she was stranded alone since January 2009. Having completed Econ. 104 just prior to arriving on the desert island (and being naturally curious), Is international trade more or less importan..

Combined sources or development of tradition : What is the date for the original writing. Who was the intended audience (province). Identify the purpose and primary themes of the book.

Regression equation where dependent variable is death rate : A friend tells you that you should never be a patient in a teaching hospital because the death rate among patients in teaching hospitals is higher than in other hospitals. Write down a regression equation where the dependent variable is the death rat..

Probability that battery will last between 11 and 15 hours : What is the probability that you must wait at least 3 minutes for the first customer - David bought a new phone. After the first 5 hours of use, the average remaining lifetime of the battery is 7 hours. Find the probability that the battery will..

Prepare a sheet for income statement and cash flow statement : prepare a sheet for income statement and cash flow statement

Which is the greatest commandment in the law : Matthew 22:36-40 states, "Teacher, which is the greatest commandment in the Law?" Jesus replied: "Love the Lord your God with all your heart and with all your soul and with all your mind

Projected economic gains from free trade : "The theory of comparative advantage (and the associated projected economic gains from free trade) is a well-known economic theory, but what happens in the real world is closer to the opposite.

Buyers to offer higher prices or persistent excess supply : Suppose the market for hamburgers is unregulated. That is, hamburger prices are free to adjust based on the forces of supply and demand. If a surplus exists in the hamburger market, then the current price must be ________(higher or lower?) than the e..

Assume that meat is sold in an unregulated market : U.S. government price supports for milk led to an unceasing surplus of milk. In an effort to reduce the surplus about a decade ago, Congress offered to pay dairy farmers to slaughter cows. Use two diagrams, one for the milk market and one for the mea..

User Account

All Pages

Prepare a sheet for income statement and cash flow statement

Reference no: EM13852665

Reference no: EM13852665

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Historical analysis purposes

Find the probability of being dealt a bridge hand of 13

You are functional managers in a relatively small but

Explain evaluation of bond receipts at various interest rate

A machine can be purchased for 10500 including

Case study the google ipo

What is the yield to call of the bond assume that interest

Determine the annual net pretax benefits

If you wanted to have 1000000 in savings at retirement how

Assume that you will receive 200000 a year in year 1

What price would an investor be expected to pay

All of general hospitals debt is at an inerest rate of 75

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT