Only Part a and b (Plan 1 & Plan 2) Using Excel only

J&J Cattle has purchased a quarter section of land for $160,000. They make a down payment of $20,000, and the remainder of the purchase price ($140,000) is financed at 11 percent compounded quarterly with quarterly payments over 2 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows

Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period.

Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period.

Plan 3: Make equal end-of-period payments.

Plan 4: Make a single payment of principal and interest at the end of the loan period. A different plan: Pay off the principal per the table below. In addition, pay the accumulated interest at the end of each interest period.

Compute the present values of the following annuities first assuming that payments are made on the last day of the period and then assuming payments are made on the first day of the period: (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) 1) 7-year, annual payment of $678.09, and YTM = 13%; 2) 13-year, annual payment of $7968.26, and YTM = 6%; 3) 23-year, annual payment of $20,322.93, and YTM = 4%; 4) 4-year, annual payment of $69,712.54, and YTM = 31%.

a. Expected Return: Discrete Distribution

A stock's return has the following distribution:

Calculate the standard deviation. Round your answer to nearest two decimal places.

b. The market and Stock J have the following probability distributions:

Calculate the standard deviation for the market and Stock J. Round your answer to nearest two decimal places.

You were recently hired as Management Director of the new I can Business Incorporated (ICBI). You have been asked to establish policeis and systems for the business. The first one you choose to work on is a financial reporting system. For this assignment, you must develop a 4-5 page memo that you will deliver to the ICBI Board of Directors. You will describe what a financial reporting system is and explain how the management team at ICBI should use an activity-based budget instead of an operating budget. Be sure to explain the similarities and the differences of the two. Finally, give examplesof the budget guidelines for ICBI. You must answer the following:

Describe the meaning and the compounds of a financial reporting system.  

Compound interest with nonannual periods​)

a. Calculate the future sum of ​$5000​, given that it will be held in the bank for 5 years at an APR of 6 percent.

b. Recalculate part a using compounding periods that are​ (1) semiannual and​ (2) bimonthly​ (every two​ months).

c. Recalculate parts a and b for an APR of 12 percent.

d. Recalculate part a using a time horizon of 12 years​ (the APR is still 6 ​percent).

e. With respect to the effect of changes in the stated interest rate and holding periods on future sums in parts c and d​, what conclusions do you draw when you compare these figures with the answers found in parts a and b​?

a. What is the future sum of ​$5000 in a bank account for 5 years at an APR of 6 ​percent?

( ) (round to the nearest cent)

Question 1 (6pts). For the cash flows shown below, answer the following questions. (Assume MARR = 12%) (1) (2pts) Provide the equation using PW to find the ROR of the cash flow given. (2) (2pts) Decide whether the project is acceptable or not using RATE function in MS Excel. Provide the screenshot (3) (2pts) Decide whether the project is acceptable or not using IRR function in MS Excel. Provide the screenshot

You are considering a project with an initial cash outlay of $80,000 and expected free cash flows of $20,000 at the end of each year for 6 years. The required rate of return for this project is 10 percent. a. What is the project’s payback period? b. What is the project’s NPV? c. What is the project’s PI? d. What is the project’s IRR? e. Indicate if the project should be accepted and why

Question: Both John and Mary are aged 20 now. John plans to contribute $100 per month in advance into his s... Both John and Mary are aged 20 now. John plans to contribute $100 per month in advance into his superannuation fund for 20 years and stop contributing thereafter. Mary plans to start contributiing $200 per month in advance into her superannuation fund at her 40th birthday until she retires. They both plan to retire at age 60. If the annual rate of return is 06.00%, what are the accumulated values of their superannuation accounts at retirement?

1. Chase Manhattan has purchased a 7 million one-year Canadian dollar loan that pays 8.5% interest annually. The spot rate of U.S. dollars for Canadian dollars is 0.70. It has funded this loan by accepting a Euro-denominated deposit for the equivalent amount and maturity at an annual rate of 7%. The current spot rate of U.S. dollars for Euros is 1.25. Note: Banks earn interest on loans and pay interest on deposits.
   1. What is the loan amount in dollars?

2. What is the deposit amount in Euros?

3. What is the interest income earned in US dollars on this one-year transaction if the spot rate of U.S. dollars for Canadian dollars and U.S. dollars for Euros at the end of the year are 0.67 and 1.30, respectively?

4. What is the interest expense in dollars?

2. Green Manufacturing, Inc., plans to announce that it will issue $2,000,000 of perpetual bonds and use these funds to repurchase equity. The bonds will have a 6-percent coupon rate. Green manufacturing currently is an all-equity firm. The current value of Green’s equity is $10,000,000 and there are 500,000 shares outstanding. After the sale of bonds and share repurchase, Green will maintain the new capital structure indefinitely. Under its current capital structure the expected annual pretax earnings for Green are $1,500,000, and these earnings are expected to remain constant into the foreseeable future. Green is in the 40-percent tax bracket.

1. What Green’s weighted average cost of capital before the debt issue?
2. Construct Green’s market-value balance sheet as it looks before the announcement of the debt issue.
3. Construct the market-value balance sheet after the announcement?
4. How many shares of stock will Green retire?
5. Construct the market-value balance sheet after the debt issue and share repurchase are completed.

Bond 1 has a 10% annual coupon rate, $1000 maturity value, n = 5 years, YTM = 10% (pays a $100 annual coupon at the end of each year and $1,000 maturity payment at maturity at the end of year 5). Bond 2 is a zero coupon bond with a $1000 maturity value, and n = 5years; YTM= 10%. (has no coupon payments; only a $1,000 maturity payment paid at maturity at the end of year 5).

What is the price, duration, and modified duration of both bonds?

Calculate the value of a bond that is expected to mature in 13 years with a 1,000 face value. The interest coupon rate is 8%, and the required rate of return is 10%. Interest is paid anually. State whether the bond is selling at a premium or at a discount.