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

  Summary of the situation

Find an example when a company took up too much risk and was unable to cope with it. Give a short summary of the situation and also provide your own comments on the following issues:

  Examine the implications of the efficient market hypothesis

Explain the risk-return relationship, examine the implications of the efficient market hypothesis for investment policy, and generalize the importance of behavioral finance in explaining market pricing anomalies.

  Decide upon an initiative you want to implement that would

decide upon an initiative you want to implement that would increase sales over the next five years for example market

  Earlier alex says somewhere in the scientific method lies

earlier alex says somewhere in the scientific method lies the answer for the needed management techniques. here alex

  A medium size firm is considering the issuance of

a medium size firm is considering the issuance of additional long-term debt to finance expansion. at the present time

  Calculate kidds exchange gain or loss if kidd receives

using the same data in problema calculate kidds exchange gain or loss if kidd receives payment from the british

  Using the graph andintuition determine whether there is a

based on what you have learned from your research on regression analysis and correlation answer the following questions

  The authorized share capital of the alfred cake company is

the authorized share capital of the alfred cake company is 100000 shares. the equity is currently shown in the companys

  Resolving ethical business challenges

Read "Resolving Ethical Business Challenges", and then address the following points. Support your response with evidence from the text.

  If comparable yields are 75 percent what must be the price

question a firm has the following preferred stocks outstandingbullpfd a 32 annual dividend 1000 par value no

  Now suppose that ttcs period of supernormal growth is to

taussig technologies corporation ttc has been growing at a rate of 20 percent per year in recent years. this same

  Find the true statement

Find the true statement regarding determination letters for qualified plans.

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