# Finance-AW-Q280

## Finance-AW-Q280 Online Services

Mortgages

1. The assumptions are a \$500,000 mortgage, a 3.875% FRM 30 and a 2.875% FRM 15 and a four year holding period.
a) . In excel,show the differential cash flows for a 5 year holding period. Determine in the Excel Worksheet the differential (or incremental) cash flows for both the selection of an FRM15 instead of an FRM30 and the FRM30 vs the FRM15.

Incremental Cash Flows FRM15
Year 1
Year 2
Year 3
Year 4
Year 5

Instructions for b) & c) below: Using an Excel worksheet (as above in a), determine the rate of return (IRR) and net present value (NPV) on the incremental cash flows from selecting either the FRM15 or the FRM30. Use the FRM30 rate as the discount rate for the NPV. Enter answers below for b) and c)

b)
IRR from selecting the FRM 15 instead of the FRM 30 =
IRR from selecting the FRM 30 instead of the FRM 15 =

c)
NPV from selecting the FRM 15 instead of the FRM 30 =
NPV from selecting the FRM 30 instead of the FRM 15 =

d)
Use the IRR above to decide which mortgage to select – the FRM15 or the FRM30. Support your answer interpreting the IRR results.

Choose the (FRM15 or FRM30). Highlight your choice..

Support your decision below

e)
If you chose the FRM15, you effectively created an incremental investment. Describe the risk of that investment.

f) What would be the monthly payments for the FRM30? (Show steps for on Excel document’s Worksheet entitled “Monthly Payment”)
Monthly Payment on FRM30 =

g) Assume the borrower is in the 20% tax bracket and itemized taxes. What are the after-tax cash flows in year 1 for the FRM30? (In “Yearly Payment”, see Lines 39&40 for a work section)
Cash flows for FRM30 in year 1 (ignoring taxes) =
The after-tax cash flows year 1 =

You can read more about our case study assignment help services here.

## How it Works

#### How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to Case Id . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

## Case Approach

#### Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

## Related Services

2. Instead of a choice between the FRM15 and the FRM30, we discussed how you could reframe the choice using only one mortgage. Identify the two correct answer(s).

a) Between an FRM15 and an FRM15 + Investment
b) Between an FRM15 and an FRM15 + Loan
c) Between an FRM30 and an FRM30 + Investment
d) Between an FRM30 and an FRM30 + Loan

3. Identify the below as true or false by entering your answer in the blank before the statement.
________In forecasting the financials to determine needs for external financing as demonstrated in Chapter 3, the answer to the external financing required (EFR) is as follows:
EFR = Assets – Debt – Equity

4. Retained earnings for 2014was \$1,580; the profit from the income statement that was forecasted for 2015 was 234; the retained earnings for 2015 was \$1,697. But \$1,580 + \$234 is not equal to \$1,697. Explain.

5. Your financial forecast indicates Assets = \$10,000; Liabilities = 6,000; Common Stock = \$1,000; Retained earnings = \$2,000. So the deficiency in funds is \$1,000. You plan to borrow to make up the deficiency. The interest rate is 10%; the tax rate is 20%; the dividend payout ratio is 25%. How much do you need to borrow to satisfy the deficiency? Show work in the Worksheet “Other” for credit.

Loan amount =

6. ROE = NI/Sales X Sales/Total Assets X Total Assets/Equity.

Total Assets/Equity involves financial leverage. Show below how Total Assets/Equity can be derived and expressed in terms of Debt/Equity.

7. Assume Company A and Company B are identical with \$4,000 in assets and both companies have an EBIT of \$500. Company A has financed its assets with all equity; Company B has financed its assets with 80% debt at a 10% interest rate and the remainder in equity. The tax rate is 25%. Compute ROA, ROE, and ROIC on the Excel Worksheet entitled ROE ROA ROIC and put the answers below. For credit, you must show your math in the Excel worksheet entitled ROE ROA ROIC.

Company A Company B
ROE =
ROA =
ROIC=

8. ROE = ROIC + (ROIC – I’) X (D/E)

Company A expects a project to provide an ROIC of 10%. Company A plans to finance the project with an interest rate of 12%. The tax rate is 30%. Will this project and its financing increase or decrease ROE?

a) Increase ROE
b) Decrease ROE

9. Referring to your decision in #8 above, show the math for your decision in the space below.

10. A B

Assets \$1,000 \$1,000
Debt None \$ 900
Equity \$1,000 \$ 100

EBIT 200 200
Int (10%) 0 90
EBT 200 110
Tx (20%) -40 -22
PAT 160 88

If you add the combined payments to shareholders and creditors, Firm A has \$18 less than Firm B. Explain.

Product Code-Finance-AW-Q280