User Account

All Pages

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

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the product and why do you think it became scarce

describe a real or made up but realistic example of a product that went through a time of scarcity when demand was

  Is the 12-month u.s. risk-free interest rate above

Is the annualized 6-month U.S. risk-free interest rate above, below, or equal to the British risk-free interest?

  Te firm can borrow at 9 if the corporate tax rate is 35

old school corporation expects an ebit of 12000 every year forever. old school currently has no debt and its cost of

  Problem on riskless security and advantage of debt financing

The semi-annual interest payments that company bonds in the U.S. typically pay are conventionally referred to as

  Each of the three financial statements measure a companys

1. name two forms of risk consideration in addition to tax.2. true or false if the value of the us is increasing stock

  Financial objective of company in maximization

The primary financial objective of a company is the maximization of the wealth of shareholders ...per corporate finance theory.    However, this objective is usually replaced by the surrogate objective of maximization of the company's share price...

  What is the return on invested capital

What is the Return on invested capital (ROIC) for the current year?

  What would likely happen without your plan being implemented

What are the advantages & disadvantages of each estate planning strategy? What would likely happen without your plan being implemented?

  Required a great deal of change

In a paper, critique a situation in either your current organization or a previous organization that required a great deal of change. Make sure, at a minimum, to address the following questions in your assessment:

  Make a profit from triangular arbitrage

Show how you can make a profit from triangular arbitrage and what your profit would be if you have $1,000,000.

  What is the price-earnings ratio

1. XYZ has total sales of $190, assets of $110, return on equity of 38%, and net profit margin of 5%. What is the amount of equity?2. ABC, Ic., has a market-to-book ratio of 3, net income of $88,714, a book value per share of $20.7, and 57,855 shares..

  What is one share of this stock worth to you today

Free Motion Enterprises paid a $2.20 per share annual dividend last week. Dividends are expected to increase by 3.75 percent annually. What is one share of this stock worth to you today if your required rate of return is 15 percent?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd