Solution-Prepare a sheet for income statement and cash flow

Prepare a sheet for income statement and cash flow statement

Assignment Help Finance Basics

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

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT