Question

In: Finance

1. Wasp Corporation has a loan agreement that provides it with cash today, and the company...

1. Wasp Corporation has a loan agreement that provides it with cash today, and the company must pay $25,000 one year from today, $15,000 two years from today, and $5,000 three years from today. Wasp agrees to pay 10% interest. Using excel compute the present value. Reminder steps are below:

1. Get into excel and go to Fx.

2. Make category financial.

3. In the rate box put the percentage in decimal format.

4. In the Nper (number of periods) put in the year criteria.

5. Pmt is the amount (to get rid of the negative you can make this a negative which will cancel it out.

6. The rest can be blank.

What is the amount of cash that Wasp receives today?

Solutions

Expert Solution

Formula for Present Value

Formula for PV method in Excel is =PV(C10,B13,0,-C13),=PV(C10,B14,0,-C14),=PV(C10,B15,0,-C15)

(If PV Method value for three year is summed up it will shows the present value of Loan amount)

Formula for Manual method in Excel is =C13/(1+C10)^B13,=C14/(1+C10)^B14,=C15/(1+C10)^B15

(If Manual Method value for three year is summed up it will shows the present value of Loan amount)

Both PV & Manual Method will show the same result in excel.


Related Solutions

Timmer Company signs a lease agreement dated January 1, 2016, that provides for it to lease...
Timmer Company signs a lease agreement dated January 1, 2016, that provides for it to lease equipment from Landau Company beginning January 1, 2016. The lease terms, provisions, and related events are as follows: • The lease is noncancelable and has a term of 5 years. • The annual rentals are $83,222.92, payable at the end of each year, and provide Landau with a 12% annual rate of return on its net investment. • Timmer agrees to pay all executory...
Timmer Company signs a lease agreement dated January 1, 2016, that provides for it to lease...
Timmer Company signs a lease agreement dated January 1, 2016, that provides for it to lease equipment from Landau Company beginning January 1, 2016. The lease terms, provisions, and related events are as follows: • The lease is noncancelable and has a term of 5 years. • The annual rentals are $83,222.92, payable at the end of each year, and provide Landau with a 12% annual rate of return on its net investment. • Timmer agrees to pay all executory...
Sax Company signs a lease agreement dated January 1, 2019, that provides for it to lease...
Sax Company signs a lease agreement dated January 1, 2019, that provides for it to lease computers from Appleton Company beginning January 1, 2019. The lease terms, provisions, and related events are as follows: 1. The lease term is 5 years. The lease is noncancelable and requires equal rental payments to be made at the end of each year. The computers are not specialized for Sax. 2. The computers have an estimated life of 5 years, a fair value of...
Adden Company signs a lease agreement dated January 1, 2016, that provides for it to lease...
Adden Company signs a lease agreement dated January 1, 2016, that provides for it to lease heavy equipment from Scott Rental Company beginning January 1, 2016. The lease terms, provisions, and related events are as follows: 1. The lease term is 4 years. The lease is noncancelable and requires annual rental payments of $20,000 to be paid in advance at the beginning of each year. 2. The cost, and also fair value, of the heavy equipment to Scott at the...
The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​...
The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​ firm's working capital. The loan called for a floating rate that was 25 basis points (0.25 percent) over an index based on LIBOR. In​ addition, the loan adjusted weekly based on the closing value of the index for the previous week and had a maximum annual rate of 2.22 percent and a minimum of 1.75 percent. Calculate the rate of interest for weeks 2...
 The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​...
 The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​ firm's working capital. The loan called for a floating rate that was 27 basis points ​(0.27 ​percent) over an index based on LIBOR. In​ addition, the loan adjusted weekly based on the closing value of the index for the previous week and had a maximum annual rate of 2.25 percent and a minimum of 1.74 percent. Calculate the rate of interest for weeks 2...
The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​...
The Bensington Glass Company entered into a loan agreement with the​ firm's bank to finance the​ firm's working capital. The loan called for a floating rate that was 27 basis points ​(0.270.27 percent) over an index based on LIBOR. In​ addition, the loan adjusted weekly based on the closing value of the index for the previous week and had a maximum annual rate of 2.16 percent and a minimum of 1.71 percent. Calculate the rate of interest for weeks 2...
An investment costs $2,921 today and provides cash flows at the end of each year for...
An investment costs $2,921 today and provides cash flows at the end of each year for 21 years. The investments expected return is 8.5%. The projected cash flows for Years 1, 2, and 3 are $101, $277, and $372, respectively. What is the annual cash flow received for each of Years 4 through 21 (i.e., 18 years)? Assume the same payment for each of these years. (Round answer to 2 decimal places. Do not round intermediate calculations).
White Corporation has entered into an agreement to transfer accounts receivable to Murphy Company. Under the...
White Corporation has entered into an agreement to transfer accounts receivable to Murphy Company. Under the terms of this agreement, White receives 80% of the value of all the transferred accounts receivable (to reflect credit risk) and is charged a 1% service charge, which is based upon the dollar amount of transferred receivables. Interest is charged at an annual interest rate of 12% of any outstanding loan balance. The transferred receivables will continue to be collected by White with any...
1) On October 1 of Year 1, the company made a $50,000 cash loan to another...
1) On October 1 of Year 1, the company made a $50,000 cash loan to another company. The interest rate on the loan is 13%. No cash payments will be collected on the loan until September 30 of Year 2. Which ONE of the following would be included in the ADJUSTING journal entry necessary on December 31 with respect to this loan? A) DEBIT to Interest Revenue for $6,500 B) CREDIT to Interest Revenue for $4,875 C) CREDIT to Interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT