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
anastassius [24]
2 years ago
15

Blank addresses change depending on the cells you

Business
1 answer:
Scorpion4ik [409]2 years ago
5 0

Answer:

absolute addresses change depending on the cells you copy them to.

relative addresses do not change if you copy them to a different cell.

Explanation:

A cell reference is a single cell or range of cells on a Excel worksheet. When calculations are done, these cells can be referred to. The cells are referred to using their row value and column value.

Relative references (or addresses) changes based on the position of rows and columns when a formula is copied to a different cell.

Absolute references (or addresses) do not change (remain constant) even if the formula is copied to a different cell.

You might be interested in
On December 31, 2020, Blossom Inc. has a machine with a book value of $1,034,000. The original cost and related accumulated depr
dangina [55]

Answer:

A)

Loss on Fire          280,720 debit

Acc depreciation 506,000 debit

Cash                     643,280 debit

      Equipment                     1,430,000 credit

B)

Acc depreciation 526,000 debit

Cash                   1,555,480 debit

      Equipment                     1,430,000 credit

     Gain at disposal                608,480 credit

C)

charitable contribution     1,645,600 debit

accumulated depreciation 500,500 debit

       equipment                                1,430,000 credit

       gain on disposal                          716,100  credit

<u>Questions</u>

A Fire completely destroys the machine on August 31, 2021. An insurance settlement of $643,280 was received for this casualty. Assume the settlement was received immediately.

B On April 1, 2021, Tritt sold the machine for $1,555,840 to Dwight Yoakam Company.

C On July 31, 2021, the company donated this machine to the Mountain King City Council. The fair value of the machine at the time of the donation was estimated to be $1,645,600.

Explanation:

In all cases, the company will write-off the equipment and acc depreciation

A.-

complete depreciation for 2020: 66,000

depreciation until August 31th: 66,000 x 8/12 = 44,000

Total depreciation 104,000

book value 1,034,000 - 104,000 = 924,000

loss: 924,000 - 643,280 = 280,72‬0

b)

complete depreciation for 2020:                   66,000

depreciation until April 31th: 66,000 x 4/12 = 22,000

Total depreciation     88,000

book value 1,034,000 - 88,000 = 946,000

1,555,480 - 946,000  = 608,480

c)

complete depreciation for 2020:                  66,000

depreciation until July 31th: 66,000 x 7/12 = 38,500

Total depreciation                                          104,500

book value 1,034,000 - 104,500 =   929,500

gain: 1,645,600 - 929,500 = 716.100

3 0
3 years ago
The demand for loanable funds depends on future income.<br><br> a. True<br> b. False
aliina [53]

Answer:

The answer is "Option b".

Explanation:

The Loanable funds are the amount of all the assets that individuals and companies have agreed to save and lend to creditors instead of for personal use, as an investment.

The earnings are also the foundation for supplying loanable funds. That request for credit funds is focused on lending. This relationship among saving provision and loan request decides its real rate as well as the sum of loans.

6 0
3 years ago
Which phrase best describes a function
Nata [24]

It is a formula containing arguments. This is because a function maps the domain to its range. Argument is synonymous to domain.

Hope this helps!

5 0
3 years ago
Machida Inc. is considering a project that is expected to produce cash inflows of $3,200 per year in years 1-4, with a final cas
PolarNik [594]

Answer:

The NPV = $1578.185602 rounded off to $1578.19

As the NPV is positive, the project should be accepted.

Explanation:

The Net Present Value or NPV is a tool used to evaluate projects. It is used with various other tools to decide whether to undertake a project or not. To calculate the Net Present Value or NPV, we take the present value of the cash inflows provided by the project and deduct the initial cost of the project.  If the NPV is positive, we should proceed with the project and vice versa.

NPV = CF1 / (1+r)  +  CF2 / (1+r)^2  +  ...  + CFn / (1+r)^n  -  Initial Cost

Where,

  • CF1, CF2, ... represents cash flow in Year 1, Year 2 and so on.
  • r is the required rate of return

NPV = 3200 / (1+0.17)  +  3200 (1+0.17)^2  +  3200 (1+0.17)^3  +  

3200 (1+0.17)^4  +  5700 (1+0.17)^5  -  9800

NPV = $1578.185602 rounded off to $1578.19

4 0
3 years ago
A local government operates on a calendar-year basis. Prepare journal entries to record the following transactions and events fo
astra-53 [7]

Answer:Please find answers in explanation column

Explanation:

1. Journal to record Short term borrowing

Date                 Account title                             Debit                  Credit

Feb. 1, 2018     Cash                                         $400,000

Tax anticipation notes payable                                                   $400,000

2.Journal to record  accrued interest payable on TAN)

Date                 Account title                             Debit                  Credit

Dec. 31, 2018   Expenditures – interest            $3,666.67  

Accrued interest payable                                                            $3,666.67  

Calculation :Accrued interest=  Principal x rate x period (time)

$400,000 x 1% x 11/12= $3,666.67  

3. Journal to record investment in  CD

Date                 Account title                             Debit                  Credit

April 1, 2018       Investments                            $100,000

                            Cash                                                                    $100,000

4.Journal To record redemption of CD with interest

Date                 Account title                             Debit                  Credit

Sept. 30, 2018          Cash                       $100,400

                               Investments                                                    $100,000

Cash Revenues – interest income                                                      $400

Calculation

Accrued Interest

Principal x rate x period (time= )100, 000 x 0.8 %x 6/12)= $400

Cash = Investment + interest= $100,000 + $400 = $100,400

4 0
3 years ago
Other questions:
  • "Bourne Incorporated reports a cash balance at the end of the month of $2,620. A comparison of the company's cash records with t
    7·1 answer
  • Oriole Company lost most of its inventory in a fire in December just before the year-end physical inventory was taken. The corpo
    5·1 answer
  • Vhat expenses do you need to budget for if you choose to rent a home? Check all that apply.
    13·2 answers
  • Why does a diverse and inclusive workforce benefit a firm supporting a global market?
    15·1 answer
  • What is MVP and what does it mean?
    7·1 answer
  • If more people join carpools and travel to work together
    7·1 answer
  • The primary weakness of EBITminusEPS analysis is that
    11·1 answer
  • What’s the answer???
    9·1 answer
  • Forte Co., had 5,900 units of work in process on April 1 that were 70% complete. During April, 18,000 units were started and as
    15·1 answer
  • a) A person has 5 trousers, 7 shirts, 6 ties, and 3 pairs of shoes. In how many possible distinct ways can the person dress
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!