User Account

All Pages

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

  A firm can raise up to 700 million for investment from a

a firm can raise up to 700 million for investment from a mixture of debt preferred stock and retained equity. above 700

  Develop competitive strategies using information systems

How does Porter's competitive forces model help companies develop competitive strategies using information systems?

  Appraise a closed burger king on hwy

You have been asked to appraise a closed Burger King on Hwy. 1 in Virginia Commons. The building was built 5 years ago, but has been vacant for the last 2. Vacant buildings tend to deteriorate faster than occupied buildings. For this reason you estim..

  Shelly sands decided to retire to hawaii in 8 yearsnbsp

shelly sands decided to retire to hawaii in 8 years.what amount should shelly invest today so that she will be able to

  Senior management at candoo graphics has numerous

senior management at candoo graphics has numerous administrative and client problems. in the past the company assigned

  What is the effective interest rate per month

James hogan is purchasing a $25,000 automobile, which is to be paid for in 48 monthly installments of $563.44. what is the effective interest rate per month for this financing arrangement?

  A bond has the following characteristics what is the bonds

a bond has the following characteristics.time to maturity 12 yearspayment frequency annualpar value 1000bond price

  Where should the abc firm borrow

It expects the euro to depreciate 6% against the $ annually, and the yen to appreciate 2% against the $. Find the effective cost of the euro and the yen loans. Where should the ABC firm borrow, and explain why?

  Statements about stock dividends

1. Which of the following statements about stock dividends is true?

  What is the relationship between risk and expected

1.what is the relationship between risk and expected return?2.how much financial risk are you willing to take? by that

  Why does the restaurant even bother to stay open because it

have you ever walked into a restaurant during lunch in downtown and found it almost empty? or flown on a flight with so

  Estimation of net present value

A proposed project can generate savings of $1000 per year for ten years. The initial cost of the project is $2500 and the project has a salvage value of $500 in the 10th year.

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