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
ddd [48]
3 years ago
10

Acceleron is planning future expansion with a new facility in Indianapolis. The company will make the move when its real estate

sinking fund has a total value of $1.2 million. If the fund currently has $400,000 and the company adds $50,000 per year, how many years will it take for the account to reach the desired value? The fund earns interest at a rate of 10% per year.
Business
1 answer:
alukav5142 [94]3 years ago
7 0

Answer:

6.67   years

Explanation:

The number of years for the firm to reach the desired value of $1.2 million can determined using the  nper formula in excel as below:

=nper(rate,pmt,pv,-fv)

rate  is the interest rate earns by the fund at 10% per year

pmt is the addition to the fund in each year which is $50,000

pv is the current amount in the fund which is $400,000

fv is the desired value of $1.2 million

=nper(10%,50000,400000,-1200000)=  6.67  years

It would take  6.67   years for the sinking fund to reach the desired value of $1,200,000

You might be interested in
Suppose that the wage rate is $30 per hour, and the firm sells each unit of output for $6. Using the data from Table 7.3, how ma
polet [3.4K]
I found this data from Table 7.3
<span> <span> </span><span><span> Labor Input Output
</span> <span> 0                          0
</span> <span> 1                          40
</span> <span> 2                          70
</span> <span> 3                          90
</span> <span> 4                       100
</span> <span> 5                       105
</span> <span> 6                       108

Labor Cost = Labor Input x 30
Output Sales = Output x 6
Revenue = Sales - Cost

</span></span></span><span> <span> </span><span><span> Labor cost        Output Sales
</span> <span> 0                                    0
</span> <span> 30                                 240
</span> <span> 60                                 420
</span> <span> 90                                 540
</span> <span> 120                               600
</span> <span> 150                               630
</span> <span> 180                               648

</span></span></span><span> <span> </span><span><span> Labor Input     Output      Labor cost    Output Sales <span>   Revenue</span>
</span> <span> 0                         0                 0                      0                        0
</span> <span> 1                        40               30                    240                   210
</span> <span> 2                        70               60                    420                   360
</span> <span> 3                        90               90                    540                   450
</span> <span> 4                     100             120                    600                   480
</span> <span> 5                     105             150                    630                   480
</span> <span> 6                     108             180                    648                   468

Labor Unit 4 and 5 both have a revenue of 480. It is the maximum revenue. I think the best option would be C. 4 UNITS.

Lesser cost to the company at a maximum revenue. </span></span></span>
6 0
3 years ago
What are examples of criteria used in conditional formatting? Check all that apply. less than equal to added to divided by great
natima [27]

Answer:

  • Less than
  • Equal to
  • Greater than

Explanation:

Considering the listed options, the criteria used in conditional formatting are Less than, Equal to and Greater than

To make use of conditional formatting, follow the highlighted steps

1. Highlight cells that you want to format

2. Goto Home tab -> Styles -> then select Conditional Format

3. Select Highlight Cells Rules

4. Select the format type (this is where you get to pick either of greater than, equal to less than, etc.)

5. Enter the format value and how it is to be formatted

6. Press OK

3 0
3 years ago
Modified multiple choice in a business letter, the inside address usually contains the addressee’s ____.
Fofino [41]
Location or which street they are on so if the people u are sending this to need to send something back then u should out your address.
5 0
3 years ago
On January 1, 20X9, Pallet Company acquires 80 percent ownership in Slat Corporation for $200,000. The fair value of the noncont
polet [3.4K]

Answer:

<em>Consolidated Assets 850,000</em>

Explanation:

We need to calcualte the alue of the purchased portion of Slat.

total assets - non-controlled = proportional owned assets

250,000 - 50,000 = 200,000

The consolidated net assets would be:

Pallet Company 650,000

Slat Company    250,000

non-controlling    (50,000)

<em>Consolidated Assets 850,000</em>

7 0
3 years ago
What is the argument in this formula? =AVERAGE(B11:H14) AVERAGE H11 B11:H14 B11
Whitepunk [10]

Answer:

The Answer is D. B11:H14

Explanation:

A got a good grade

8 0
3 years ago
Other questions:
  • You are the county commissioner of hazard county. jeb brings a complaint before you that​ dwight's hog farm is creating a terrib
    11·1 answer
  • According to John Rawls, those in the original position must choose the principles of justice in ignorance of all of the followi
    13·1 answer
  • Techup inc., a manufacturer of computer chips, hires an external specialist agency to perform background checks of its new emplo
    7·1 answer
  • Landon Corporation was organized on January 2, 2014, with the investment of $120,000 by each of its two stockholders. Net income
    11·1 answer
  • KST Mart has large amounts of customer data. To understand customer purchase behavior, the company uses a process that automatic
    14·1 answer
  • On November 1, 2013, Wenger Co. paid its landlord $4,260 in cash as an advance rent payment on its store location. The six-month
    13·1 answer
  • Which one of these statements is correct? Multiple Choice All allocated costs should be included in the initial cost of a projec
    8·1 answer
  • 1. Read the information in the chart about two trading partners. Then answer the question that follows. Based on the information
    9·1 answer
  • A firm has forecasted sales of $4,500 in April, $3,000 in May, and $5,000 in June. All sales are on credit. 30% is collected in
    7·1 answer
  • Interview Notes
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!