Question

In: Finance

A. Wissler, Inc. owes $273,000 to the bank for some improvements made to its office building....

A.

Wissler, Inc. owes $273,000 to the bank for some improvements made to its office building. The loan is for 60 months and the monthly payment is $5,945.79 What is the interest rate on the loan?

B.

Huggins Co. has identified an investment project with the following cash flows.

    

Year Cash Flow
1 $ 790
2 1,070
3 1,330
4 1,450

  

If the discount rate is 9 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  

  Present value $   


What is the present value at 17 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  

  Present value $   

  

What is the present value at 25 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  

  Present value $   

Solutions

Expert Solution

A.

Wissler, Inc. owes $273,000 to the bank for some improvements made to its office building. The loan is for 60 months and the monthly payment is $5,945.79 What is the interest rate on the loan?

RATe ?
NPER 60
PV 273000
FV 0
PMT 5945.79
=RATE(60,5945.79,-273000,0,0)*12 11.07%

Huggins Co. has identified an investment project with the following cash flows.

If the discount rate is 9 percent, what is the present value of these cash flows?

PV factor 9% PV
1 790 0.917431 724.77
2 1070 0.841680 900.60
3 1330 0.772183 1027.00
4 1450 0.708425 1027.22
Present value 3679.59

What is the present value at 17 percent?

PV factor17% PV
1 790 0.854701 675.21
2 1070 0.730514 781.65
3 1330 0.624371 830.41
4 1450 0.533650 773.79
Present value 3061.07

What is the present value at 25 percent?

PV factor17% PV
1 790 0.800000 632.00
2 1070 0.640000 684.80
3 1330 0.512000 680.96
4 1450 0.409600 593.92
Present value 2591.68

Related Solutions

Beaumont company recently purchased some real estate that contained, land improvements (parking lot) and a building....
Beaumont company recently purchased some real estate that contained, land improvements (parking lot) and a building. Beaumont has the property appraised after the purchase. The information is below: Land Purchase          375,927 Land Appraisal          175,000 Improvement appraisal            87,000 Building Appraisal          210,000 1 Allocate the total cost to the three assets Asset Description Appraisal Values Percent of Total Appraised Value x total acquisition cost = allocated cost Land       Land improvements          Building Totals 1...
The roof of your corporation’s office building recently suffered some damage as the result of a...
The roof of your corporation’s office building recently suffered some damage as the result of a storm. You, the president of the corporation, are negotiating with a carpenter who has quoted two prices for the repair work: $600 if you pay in cash (“folding money”) and $700 if you pay by check. The carpenter observes that the IRS can more readily discover his receipt of a check. Thus, he hints that he will report the receipt of the check (but...
Conference Services Inc. has leased a large office building for $4 million per year. The building...
Conference Services Inc. has leased a large office building for $4 million per year. The building is larger than the company needs: two of the building's eight stories are almost empty. A manager wants to expand one of her projects, but this will require using one of the empty floors. In calculating the net present vlaue of the proposed expansion, upper management allocates one-eighth of $4 million of building rental costs (i.e., $.5 million) to the project expansion, reasoning that...
Edmund Corporation recently made a large investment to upgrade its technology. Although these improvements won’t have...
Edmund Corporation recently made a large investment to upgrade its technology. Although these improvements won’t have much of an impact on performance in the short run, they are expected to reduce future costs significantly. When would it be consistent with the manager’s fiduciary(maximize stockholder wealth) to accept the project? Further, can you describe a situation under which a manager may not accept the project even if it is consistent with his/her fiduciary responsibility? Make sure you clearly explain how it...
FIN343 Bank estimates that building a new branch office in the newly developed New Heaven township...
FIN343 Bank estimates that building a new branch office in the newly developed New Heaven township will yield an annual expected return of 10 percent with an estimated standard deviation of 6 percent. The bank's marketing department estimates that cash flows from the proposed New Heaven branch will be strongly positively correlated (with a correlation coefficient of + 0.70) with the bank's other sources of cash flow. The expected annual return from the bank's existing facilities and other assets is...
Splish, Inc. began work on a $6,312,000 contract in 2020 to construct an office building. During...
Splish, Inc. began work on a $6,312,000 contract in 2020 to construct an office building. During 2020, Splish, Inc. incurred costs of $1,589,940, billed its customers for $1,156,000, and collected $894,000. At December 31, 2020, the estimated additional costs to complete the project total $3,228,060. Prepare Splish’s 2020 journal entries using the percentage-of-completion method. (Credit account titles are automatically indented when amount is entered. Do not indent manually. For costs incurred use account Materials, Cash, Payables. If no entry is...
Crane, Inc. began work on a $7,016,000 contract in 2020 to construct an office building. During...
Crane, Inc. began work on a $7,016,000 contract in 2020 to construct an office building. During 2020, Crane, Inc. incurred costs of $1,798,560, billed its customers for $1,125,000, and collected $910,000. At December 31, 2020, the estimated additional costs to complete the project total $3,197,440. Prepare Crane’s 2020 journal entries using the percentage-of-completion method. (Credit account titles are automatically indented when amount is entered. Do not indent manually. For costs incurred use account Materials, Cash, Payables. If no entry is...
Stellar, Inc. began work on a $6,491,000 contract in 2020 to construct an office building. During...
Stellar, Inc. began work on a $6,491,000 contract in 2020 to construct an office building. During 2020, Stellar, Inc. incurred costs of $1,941,020, billed its customers for $1,138,000, and collected $904,000. At December 31, 2020, the estimated additional costs to complete the project total $3,304,980. Prepare Stellar’s 2020 journal entries using the percentage-of-completion method. (Credit account titles are automatically indented when amount is entered. Do not indent manually. For costs incurred use account Materials, Cash, Payables. If no entry is...
A new space heating system is considered for a small office building at Dragon Ball Inc....
A new space heating system is considered for a small office building at Dragon Ball Inc. The new system can be acquired with an initial cost of 750,000 which requires annual maintenance which will cost about $5,000. The new heating system is expected to reduce power consumption by 400,000 kilowatt-hours per year for the entire investment period. The salvage value of this equipment is considered as $20,000 at the end of a 10-year use. Assuming an electricity cost of $0.25...
Sarasota, Inc. began work on a $6,504,000 contract in 2020 to construct an office building. During...
Sarasota, Inc. began work on a $6,504,000 contract in 2020 to construct an office building. During 2020, Sarasota, Inc. incurred costs of $1,639,900, billed its customers for $1,300,000, and collected $1,055,000. At December 31, 2020, the estimated additional costs to complete the project total $3,650,100. Prepare Sarasota’s 2020 journal entries using the percentage-of-completion method. (Credit account titles are automatically indented when amount is entered. Do not indent manually. For costs incurred use account Materials, Cash, Payables. If no entry is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT