1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lubov Fominskaja [6]
3 years ago
6

Prepare a personal budget for one month. Be sure to think through your sources of income and expenses. Be as detailed as you wis

h; but include cells that calculate the following: Income (which calculates the sum of all income sources), Expenses (which calculates the sum of all expenses), and Savings (which calculates the difference between the total income and expenses). After completing your budget, complete the tasks to create named ranges that reference the important cells outlined above. This set of tasks as a total of 10 points.
1.Create a named range called, "Income" that references the cell that calculates the total income in your budget. [3 points]

2. Create a named range called, "Expenses" that references the cell that calculates the total expenses in your budget. [3 points]

3. Create a named range called, "Savings" that references the cell that calculates the monthly savings in your budget. The savings calculation should be the difference between the total income and total expenses in your budget. Be sure to reference the named ranges for income and expenses in your calculations.
Business
1 answer:
olchik [2.2K]3 years ago
4 0

Answer:

ikn  

Explanation:

vgrhn nm mbjnbbvb

You might be interested in
1. Albacore Corporation purchased a new machine costing $27,600 on January 1, 2017. The machine is expected to have a $1,800 sal
docker41 [41]

Answer:

Annual depreciation= $4,300

Explanation:

Giving the following information:

Purchasing price= $27,600

Salvage value= $1,800

Useful life= 6 years

To calculate the depreciation expense using the straight-line method, we need the following formula:

Annual depreciation= (original cost - salvage value)/estimated life (years)

Annual depreciation= (27,600 - 1,800) / 6= $4,300

7 0
3 years ago
Suppose you buy a 7 percent coupon, 20-year bond today when it’s first issued. If interest rates suddenly rise to 15 percent, wh
Mariana [72]

Answer: The value of the bond will decrease

Explanation:

The Interest rate has a negative inverse relationship with the value of a bond . When the interest rate increases the value of a bond decreases and when interest rate decreases  the bond value increases. Bonds with low coupon rates tend to be more sensitive to interest rate changes this is known has coupon effect.

Bonds with long time frame (long term bonds), they also  tend to be are more sensitive to changes in the interest rate this is known has the maturity effect.  Therefore a change in the interest rate will cause a huge change in the value of a Bond with low coupon rate and long time period.

The Bond is a 20 year Bonds which qualifies it to be a long term bond and the coupon Rate is 7%, with these facts and knowing that  long term bonds are more sensitive to interest rate changes we can conclude that the sudden increase of the interest rate to 15%  will cause a huge decrease in the value of the bond

5 0
3 years ago
he following data are to be used for Questions 4 and 5. The parentheses indicate amounts that should be subtracted in the comput
ivann1987 [24]

Answer:

t= 0.4138

Explanation:

First, we need to accommodate the information:

Sales= 10,000

COGS= 6000 (-)

Gross profit= 4000

Operating, selling, general and administrative expenses= 2300 (-)

Net operating income= 1700

Interest= 250 (-)

Earnings before taxes= 1450

TAX= 600 (-)

Net income= 850

t= ?

t= 600/1450= 0.4138

5 0
3 years ago
Nathan and Diana are married and have three married children and seven minor grandchildren. For tax year 2020, what is the maxim
Luba_88 [7]

Answer:

Maximum amount that can be given to family (including the sons- and daughters-in-law) without using unified transfer tax credit is $390,000.

Explanation:

Given the data in the question;

Nathan and Diana are married and they have 3 married children, meaning Nathan and Diana also have 3 daughters/sons in law married to their children. In addition, they have 7 minor grand children.

Number of donees will be ⇒ 3 + 3 + 7 = 13

Now, we know that; The annual gift tax exclusion for 2019-2020 is $15,000 per donee or individual for every tax payer while that of married couple is $30,000.

Meaning Nathan and Diana can give $30,000as a gift to each of their family members without using any of their unified transfer tax credit.

Hence,

Maximum amount that can be given to family (including the sons- and daughters-in-law) without using unified transfer tax credit will be;

⇒ 13 × $30,000

= $390,000.

6 0
3 years ago
Changes in the prices of key commodities have a significant impact on a company's bottom line. For virtually all companies, the
Anna11 [10]

Answer:

Explanation:

A) Energy can be both a fixed cost and a variable cost for a company. This is due to the sense that energy in the form of fixed electricity bill even when no production takes place (telephone bill), a fixed cost and electricity bill when production takes place would be a variable cost

B) An increment in fixed cost will shift the ATC curve to the right while the MC curve would remain the same because MC is the change in variable cost as output increases and is not related to fixed cost.

C) Corn cost is a variable cost for ethanol producer as each unit of corn is used to produce ethanol and thus use of corn is reliant upon how much ethanol is produced. This makes corn a variable input dependent on the production of output, therefore, the cost of corn is variable.

D) An increment in the variable cost will shift the ATC curve to the right and individual MC curve to the right.

5 0
3 years ago
Other questions:
  • The payroll register of Charbroil Company indicates $1,200 of social security tax withheld and $300 of Medicare tax withheld on
    15·1 answer
  • Janice works as a consultant for a tech company. In the past, the company has relied heavily on its toll-free line to sell new p
    6·2 answers
  • 8. The purpose of a flexible budget is to: A. remove items from performance reports that are not controllable by managers. B. pe
    10·1 answer
  • Webster and Moore paid $148,000, in cash, for equipment three years ago. At the beginning of last year, the company spent $21,00
    8·1 answer
  • Labracorp is looking to hire an unknown number of workers. jim wants to be one of those workers. what information would labracor
    7·2 answers
  • The firm is currently in the process of forecasting sales, asset requirements, and required funding for the coming year. In the
    5·1 answer
  • State University sold all of its basketball tickets to its students for 15 home games on September 30 for​ $1,200,000 (basketbal
    7·1 answer
  • Language usage, delivery, and presentation aids fall under the ______ stage of informative speaking.
    12·1 answer
  • Shannon is a marketing agent who determines his work behavior solely on whether he thinks he can do them without receiving immed
    9·1 answer
  • Zack Shields leases a manufacturing facility that produces computer monitors. Zack tries to keep production high, because his le
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!