Calculate the total for all the cells

Assignment Help Accounting Basics
Reference no: EM13818017

Create a business budget sheet using Microsoft® Excel®. In the budget sheet do the following:

  • Create a label called "Income" and add your monthly business income in the next cell: $42000.
  • Add a label called "Rent" and enter the amount in the next cell: -$2000.
  • Add a label called "Product Spending" and enter the amount in the next cell: -$20000.
  • Add a label called "Gas" and add the amount in the next cell: -$250.
  • Add a label called "Car Payment" and add the amount in the next cell: -$500.
  • Add a label called "Electric" and add the amount in the next cell: -$600.
  • Add a label called "Insurance" and add the amount in the next cell: -$500.

Use the SUM function to calculate the total for all the cells.

Use the Freeze option to freeze the top panes.

Create a pie chart for your business income and spending

Reference no: EM13818017

Questions Cloud

The wage elasticity of labor supply for men aged : The wage elasticity of labor supply for men aged 18-25 is measured to be 0.3. Within this group, the average weekly wage of the high school graduates is 2/3 the amount of college graduates. Assume that wage elasticity and all other individual charact..
Application on influence of the courts : Application on Influence of the Courts
Determine the target wacc for apix printing : We can determine the target WACC for Apix Printing Inc., given these assumptions," she says as she hands you a piece of paper that says the following:
What is the rationale presented for the change : What is the rationale presented for the change? What are the internal and external pressures considered in the change? To what extent are single versus multiple rationales utilized?
Calculate the total for all the cells : Use the SUM function to calculate the total for all the cells. Use the Freeze option to freeze the top panes.
How tocreate a threepoint estimate for the resulting budget. : You need to determine the costs of this mailing (internal and external). You also need to determine the resource requirements and identify any conflicts. In preparation for the meeting, create a worksheet (in Excel or another spreadsheet tool) that y..
Identify pressures that have caused ethical and legal issues : Discuss the corporate ethical issues of providing questionable products to other markets. Identify the pressures that have caused the ethical and legal issues in this scenario to arise.
Diminishing marginal returns to studying sets : Chris is preparing for a comprehensive course exam by reading a textbook with chapters of equal length and difficulty. The number of chapters she can comprehend and master when studying is: (1) hour one: 1.5 chapters; (2) hour two: 2.0 chapters; (3) ..

Reviews

Write a Review

Accounting Basics Questions & Answers

  Calculate the gain or loss on the sale of the asset

Blue should have taken $455 and $3,636 cost recovery in 2005 and 2006. On January 1, 2007, the asset was sold for $98,000. Calculate the gain or loss on the sale of the asset in 2007.

  What were the most critical choices faced by james milmo

What were the most critical choices faced by James Milmo early in the founding of Lynx? Do you agree with his decisions? 2. Has the founding team done a good job of structuring itself and building the Lynx organization?

  Data pertaining to the postretirement health care benefit

data pertaining to the postretirement health care benefit plan of sterling properties include the following for 2013 in

  A companys required rate of return on capital budgeting

1. a companys required rate of return on capital budgeting projects is 15. the company is considering an investment

  Which accounting principle requires reporting credit card

which accounting principle requires reporting credit card expense in the same period as its related credit card

  How many sets of clubs must be sold for tee times

Tee Times, Inc. produces and sells the finest quality golf clubs in all of Clay County. The company expects the following revenues and costs in 2009 for its Elite Quality golf club sets.

  Monster company produces a product requiring 3 direct labor

monster company produces a product requiring 3 direct labor hours at 16.00 per hour. during january 2000 products are

  A broad principle that requires identifying the activities

a broad principle that requires identifying the activities of a business with specific time periods such as months

  On july 1 2012 an interest payment date 80000 of parks co

on july 1 2012 an interest payment date 80000 of parks co. bonds were converted into 1600 shares of parks co. common

  Service company example international finance incorporated

Two-Variance Analysis: Service Company Example International Finance Incorporated issues letters of credit to importers for overseas purchases.

  A study indicates that 377000 of the fixed expenses being

boyles home center a retailing company has two departments bath and kitchen. the companys most recent monthly

  Ivy industrial packing co purchased a packing machine for

ivy industrial packing co purchased a packing machine for 950000 at the beginning of 2009. the robot has an estimated

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!

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