Question

In: Economics

A small construction company has $100,000 set aside in a capital improvement fund to purchase new...

A small construction company has $100,000 set aside in a capital improvement fund to purchase new equipment. If $30,000 is invested at 30%, $20,000 at 25%, and the remaining $50,000 at 20% per year, what is the overall rate of return on the entire $100,000? using spreadsheet

Expert Solution

We will increase each number (30,000; 20,000; 50,000) as per their percentages increase, then we will add them to find a sum of all increased number. The sum thus obtained will be compared with 100,000 (which is our initial sum of numbers 30,000 ; 20,000 and 50,000 without any percentage increase).

With this we will be able to find the percentage change in the overall sums which will give us overall return on the entire sum.

30% increase in 30,000 = (1+30%) * 30,000

= (1+ 0.30) * 30,000 = 1.3 * 30,000 = 39,000.

25% increase in 20,000 = (1+25%) * 20,000

= (1+0.25) * 20,000 = 1.25 * 20,000 = 25,000

20% increase in 50,000 = (1+20%) * 50,000

= (1+0.20) * 50,000 = 1.2 * 50,000 = 60,000.

Now we will sum the outputs obtained in the steps above:

39,000 + 25,000 + 60,000 = 124,000.

This result shall be compared with 100,000 to find the overall return.

Overall rate of return or percentage change = (Final Sum - Initial Sum ) / Initial Sum

= 124,000 - 100,000 / 100,000

= 24,000 / 100,000

= 0.24

= 24%.

Hence, the overall rate of return is 24%.

Rahul Sunny answered 7 months ago

A wood products company has decide to purchase new logging equipment for $100,000 with a trade...

A wood products company has decide to purchase new logging equipment for $100,000 with a trade in of its old equipment. The old equipment has a BV of $10,000 at the time of the trade in. The new equipment will be kept for 10 years before being sold. It’s estimated SV at the time is expected to be $5,000. Using the SL method, the BV at the end of the despreciable life is?

A small company wishes to set up a fund that can be used for technology purchases...

A small company wishes to set up a fund that can be used for technology purchases over the next 6 years. Their forecast is for $22,000 to be needed at the end of year 1, decreasing by $2,000 each year thereafter. The fund earns 9% per year. How much money must be deposited to the fund at the end of year 0 to just deplete the fund after the last withdrawal? $

Srorm Software wants to issue $100 million ($1,000 x 100,000 bonds) in new capital to fund...

Srorm Software wants to issue $100 million ($1,000 x 100,000 bonds) in new capital to fund new opportunities. If Storm raised the $100 million of new capital in a straight-debt 20-year bond offering, Storm would have to offer an annual coupon rate of 13%. However, Storm's advisers have suggested a 20-year bond offering with warrants. According to the advisers, Storm could issue 10% annual coupon-bearing debt with 28 warrants per $1,000 face value bond. Storm has 10 million shares of...

1) Colorado Mattress Company is considering the purchase of land and the construction of a new...

1) Colorado Mattress Company is considering the purchase of land and the construction of a new plant. The land, which would be bought immediately (at t = 0), has a cost of $200,000 and the building, which would be erected at the end of the first year (t = 1), would cost $800,000. It is estimated that the firm's after-tax cash flow will be increased by $150,000 starting at the end of the second year, and that this incremental flow...

A construction company is considering acquiring a new earthmover. The purchase price is $110,000, and an...

A construction company is considering acquiring a new earthmover. The purchase price is $110,000, and an additional $25,000 is required to modify the equipment for special use by the company. The equipment falls into the MACRS seven-year classification (the tax life), and it will be sold after five years (the project life) for $50,000. The purchase of the earthmover will have no effect on revenues, but the machine is expected to save the firm $68,000 per year in before-tax operating...

Chapter 5 Recording Capital Asset Transactions Street Improvement Capital Projects Fund and Governmental Activities at the...

Chapter 5 Recording Capital Asset Transactions Street Improvement Capital Projects Fund and Governmental Activities at the Government-wide Level During late 2016, the voters of the City of Smithville authorized tax-supported bond issues totaling $8,000,000 as partial financing for a series of projects to construct streets, curbs, culverts, and storm sewers in various parts of the city. The estimated total cost of the series of projects, which are expected to extend over the next three years, was $10,200,000. In addition to...

A fund has 100,000 at the start of the year. Six months later, the fund has...

A fund has 100,000 at the start of the year. Six months later, the fund has a value of 75,000 at which time, Stuart adds an additional 75,000 to the fund. At the end of the year, the fund has a value of 200,000. Calculate the exact dollar weighted rate of return.

Jane has been offered a Price Level Adjusted Mortgage Loan of 100,000 to purchase a small...

Jane has been offered a Price Level Adjusted Mortgage Loan of 100,000 to purchase a small bar. The loan is to be amortized over 25 years, with annual payments. The rate is j1 = 4%. Annual inflation rates are as follows: Year 1-3 4% Year 4-6 3% (a) What is the adjusted OSB at the end of 3rd year?

Patricia, a CPA, is the new controller for a small construction company, Domingo Builders, that employs...

Patricia, a CPA, is the new controller for a small construction company, Domingo Builders, that employs 75 people. The company specializes in custom homes greater than 3,500 square feet. The demand for large custom homes has significantly decreased because of the downturn in the economy. As a result of economic conditions their target market is dwindling, significantly affecting the company’s finances. The ability to collect an outstanding receivable that is significant and material is in doubt. Prior to year-end Patricia...

Economy A family has borrowed $100,000 to purchase a new home. The interest rate is fixed...

Economy A family has borrowed $100,000 to purchase a new home. The interest rate is fixed at 12% compounded monthly over the 25-year life of the loan. Find the remaining balance on the loan immediately after the payment listed Also find the amount of interest that comprises the payment listed. Payment 30 please answer in detail