Use the sum function to calculate the total for all the cell

Assignment Help Finance Basics
Reference no: EM13910458

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.

Save this document as Lastname_BusinessBudget_W3.xls

Reference no: EM13910458

Questions Cloud

Number of internet services in an area : In certain part of the country ,there is an average of 710 people per square mile and o.72 internet services per person . what is the number of internet services in an area of 5.0km square?
Reaction between potassium chlorate : The reaction between potassium chlorate and red phosphorus is highly exothermic and takes place when you strike a match on a matchbox. If you were to react 52.9 g of potassium chlorate (KCl03) with red phosphorus,
What socio-economic issues of india from mnc manufacturing : What are the socio-economic issues of India from a MNC manufacturing company view? Need analysis describe the appropriate techniques and procedures for mitigating the risks identified for India.
Use the sum function to calculate the total for all the cell : 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..
Selling administrative and depreciation expenses : Selling, administrative, and depreciation expenses for the month were $20,000. BrightStar's tax rate is 35 percent. Use this information and the table above to complete the following: Calculate the cost of ending inventory and the cost of goods sold ..
Final volume and the methyl chloride : A 10 mg of methyl chloride vapor is added to one liter of nitrogen at 20 C. Pressure is kept constant at 1 atmosphere. What is the final volume and the methyl chloride concentration in mg/cu m and ppmv?
Find the weight difference for both cases : A spherical balloon contains 10m^3 of helium at 1 atmosphere and 0C. What will be the diameter of the balloon at the altitute of 3.2 kilometer, where the temperature are -7C and 85000 N/m^2 respectively? What would be the diameter of the balloon i..
How much will she make on the option : The investor pays $4.80 per share for the options. At the end of three months, SoftKiss stock is selling for $47 per share. The investor can sell the option for $17.50 per share. If she does indeed sell all 7 of the put option contracts, how much ..

Reviews

Write a Review

Finance Basics Questions & Answers

  What capital gain will brighton report on this transaction

Brighton depreciates oil rigs straight line over 10 years assuming no salvage value. The rig was just sold to British Petroleum for $25,000,000. What Capital Gain/Loss will Brighton report on this transaction?

  Find the values assuming a regular or ordinary annuity

1. Find the following values assuming a regular, or ordinary, annuity: a. The present value of $400 per year for ten years at 10 percent b. The future value of $400 per year for ten years at 10 percent c. The present value of $200 per year for five y..

  Computation of weighted average cost of capital

Computation of weighted average cost of capital and construct a pro forma balance sheet that indicates the firm's optimal capital structure

  John takes a long position in a call on a stock

John takes a long position in a call on a stock with a certain exercise price and selling a call option on the same stock with higher exercise price. Draw his total payoff diagram?

  What is the proper cash flow amount to use

What is the proper cash flow amount to use as the initial investment in fixed assets when evaluating this project?

  Determine the value of portfolio today

Suppose you invested $10,000 eight years ago. The arithmetic average is 10.9 percent and the geometric average return is 10.5%. What is the value of your portfolio today

  Calculate the residual income for each division

Calculate the residual income (RI) for each division. Calculate EVA for each division and comment on your answers for ROI, RI, and EVA.

  What is the holding period return to an investor

What is the holding period return to an investor who bought 100 shares of Charter Oil nine months ago for $36 a share, received two $50 dividend checks, and sold the stock today at $38 a share?

  Return on investment-education funding

Return on Investment - Education Funding. Develop a three to five page analysis on the projected return on investment for your college education and projected future employment. This analysis will consist of two parts.

  What is the present value of cash flow stream

What is the present (Year 0) value of cash flow stream if the opportunity cost rate is 10 percent?

  If this is the companys only note what amount should the

a company borrowed 100000 from a bank on july 1 2004. the company made monthly payments of 5235 on the note at the end

  What is the accounts receivable period

The Gift Mart has sales of $832,000 and cost of goods sold of $591,000. What is the accounts receivable period if the average receivables balance is $63,400?

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