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
Pie
3 years ago
7

Does anyone know how to create a budget?

Business
1 answer:
nadya68 [22]3 years ago
4 0
Step 1: Create a New Workbook. The first step is to create a new workbook when you open Microsoft Excel. ...
Step 2: Enter Income and Expenses. ...
Step 3: Add Formulas. ...
Step 4: Compare Income to Expenses. ...
Step 5: Save Your Spreadsheet.
You might be interested in
Peter wishes to create a retirement fund from which he can draw when he retires and the same amount at each anniversary of his r
uranmaximum [27]

Answer:

$65,742.60

Explanation:

Note: The full question is <em>"Peter wishes to create a retirement fund from which he can draw $20,000 when he retires and the same amount at each anniversary of his retirement for 10 years. He plans to retire 20 years from now. What investment need he make today if he can get a return of 5% per year, com- pounded annually?"</em>

At first, we need to find the PV of withdrawals and there are 11 withdrawals starting 20 years from now.  

PV = PMT/r * 1 - 1/(1+r)^n. This formula gives the PV one period before the first withdrawal. That is 19 years from now because the first withdrawal is 20 years from now.

PMT = 20,000, n = 11,  

r = 0.05

PV19 = 20,000/0.05 * [1 - 1/(1+0.05)^11]

PV19 = 400,000 * 0.4153207109

PV19 = 166,128.28436

Now, we need to discount this back to toda

PV0 = PV19/(1 + r)^n; n = 19, r = 0.05

PV0 = 166,128.28436/(1 + 0.05)^1

PV0 = $65,742.6033421702

PV0 = $65,742.60

So, Peter needs to make $65,742.60 today.

3 0
2 years ago
Hunter Sailing Company exchanged an old sailboat for a new one. The old sailboat had a cost of $210,000 and accumulated deprecia
dezoksy [38]

Answer: Gain of $12,000

Explanation:

First off, what was the Net book value of the old sailboat?

= Cost Price - Accumulated Depreciation

= 210,000 - 84,000

= $126,000

They paid $101,000 in cash and received a trade in allowance of $138,000 bringing the value to $239,000.

What they should have received as the trade in allowance was the NBV of $126,000. Since they didn't they got a gain of,

= 138,000 - 126,000

= $12,000

Because this transaction has commercial substance, the gain would be $12,000.

6 0
3 years ago
Basel lll mainly focuses on _.​
icang [17]
To strengthen requirements from basel ll on the bank’s minimum capitol ratios.
8 0
3 years ago
Mayree is the owner of Spines Books, a small eclectic-style bookstore in a bustling college town. Mayree prides herself in selec
Mila [183]

Answer:

Inventory turnover

Explanation:

From the question we are informed Mayree who is the owner of Spines Books, a small eclectic-style bookstore in a bustling college town. Mayree prides herself in selecting hard-to-find books and magazines that her clientele enjoy. Recently, Mayree is experiencing a cash flow shortage, and she is concerned that she may be purchasing too many copies of each title. Having recently completed a business class, I can suggest to Mayree that she calculate the Inventory turnover ratio for her store, and then compare it to other stores in her industry. Inventory turnover can be regarded as rate at which particular company make sales of it's stock of goods and make replacement of its stock of goods during a particular period.

The inventory turnover ratio can be regarded as formula which is cost of goods that is been sold divided by average inventory within the same period.

Mathematically,

inventory turnover=[Net sales/ Average inventory at particular selling price]

3 0
2 years ago
Choose the best word or phrase from each drop-down menu. the federal reserve increases the money supply when it is trying to enc
Pie

Because raising the money supply boosts the economy, the optimal sentence from the drop-down box is (i) or (a).

<h3>What happens when federal reserves increase?</h3>

Increasing the money supply has a number of consequences which are:

To boost the economy, the Federal government expands the money supply.

Customers use credit because interest rates are lower when the money supply is high.

The unemployment rate is reduced when the money supply is increased.

When the money supply is increased, the economy generally grows because people have more money to spend.

As the amount of money available increases, loans will become more affordable, encouraging people to take out loans knowing that they will just have to pay lesser interest rates.

To learn more about money supply, refer below

brainly.com/question/13399132

4 0
2 years ago
Read 2 more answers
Other questions:
  • What are the major benefits to IKEA of shifting so much of its global production to China? concentration of manufacturing assets
    9·1 answer
  • Securities issued by all of the following organizations are exempt from the registration requirements of the 1933 Securities Act
    12·1 answer
  • The constraint at Rauchwerger Corporation is time on a particular machine. The company makes three products that use this machin
    9·1 answer
  • The PGA operates as two divisions: one that governs the club professionals who serve amateur players and another, known today as
    5·1 answer
  • What two words are often associated with centrally planned economies?
    12·2 answers
  • 1) Suppose at market opening on 10/24/2019, the market expects the bond that matures in 2034 ("the longer-term bond") to provide
    9·1 answer
  • Bradley is watching an interesting TV program with a group of friends. During the commercial break, he is unable to concentrate
    9·1 answer
  • John Taxpayer had a gross income of $2823,08 and $892.34 in deductions, How
    12·1 answer
  • Pls help me and thanks
    7·2 answers
  • Gerritt wants to buy a car that costs $28,250. The interest rate on his loan is 5.45 percent compounded monthly and the loan is
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!