Exercise #6

Directions: Review the following scenario and answer the question that follows: Scenario: Date of the writedown: 5/01/15 FO loan dated 12/15/2007 in the amount of $200,000 at 5% interest Amount of the writedown: $24,123 Unpaid principal and interest as of the date of the writedown: $168,123.08 Market value of the property securing the note: $144,000 The borrower is selling the security on 6/15/17 for the appraised value of $175,000. A year prior to the sale, the borrower built a small barn on the property which provides a contributory value of $20,000 according to the appraisal. 1. Calculate the amount of Shared Appreciation due.

Prepare a duration table under the following assumptions a. $100,000 fully amortizing loan b. Annual payments c. 20-year amortization d. 7% stated rate e. 7% yield

Financial accounting question not used ai

Correct pls thNks

ONLINE 721757 K Complete the first month of the amortization schedule for a fixed-rate mortgage. Mortgage: $110,000 Interest rate: 6.5% Term of loan: 25 years Click the icon to view the Real Estate Amortization Table. Payment Number 1 Amortization Schedule Total Payment Interest Payment Principal Payment Balance of Principal (a) $ (b) $ (b) $ (d) $

please answer in excel

Type of Loan/Investment Automobile loans Furniture loans Other secured loans Signature loans Risk-free securities $1540000 $440000 $ 220000 $ 660000 Annual Rate of Return (%) xxx> 9 What is the projected total annual return? $514800 11. The credit union will have $2,200,000 available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition . Risk-free securities may not exceed 30% of the total funds available for investment. • Signature loans may not exceed 10% of the funds invested in an loans (automobile, furniture, other secured, and signature loans). . Furniture loans plus other secured loans may not exceed the automobile loans. Other secured loans plus signature loans may not exceed the furids invested in risk-free securities. 12 How should the $2,200,000 be allocated to each of the loan/investment alternatives to maximize total annual return? Automobile loans $ 22 Furniture loans Other secured loans Signature…

list K Complete the first month of the amortization schedule for a fixed-rate mortgage. Complete parts (a) through (d). Mortgage: $103,000 Interest rate: 5.5% Term of loan: 15 years Click the icon to view the Real Estate Amortization Table. Complete the first payment of the amortization schedule. (Do not round until the final answer. Then round to the nearest cent as needed.) Amortization Schedule Payment Number 1 Total Payment (a) $841.60 Interest Payment ... (b) $472.03 Principal Payment (c) $369.57 Balance of Principal Save (d) $472.03

Written Work No.3: SIMPLE INTERESTS etions: Complate the tuhla bolow. Show your solution on a saparate sheet. Maturity Value (P) Principal (P) Rate Time Interest (P) 1 year & 5 months 1. 1,000 3.50% 2. 0.85% 2.25 years 1,250 3. 50,000 0.005% 2,750 4. 36,700 690 5. 10.20% 25.000 950,000 6. 25.000 19.000

er A https://player-ui.mheducation.com/#/epub/sn_7cac#epubcfi(%2F6%2F326%5Bdata-uuid-ab153a0624d544c2822 6. Comparing Total Mortgage Payments. Which mortgage would result in higher total payments? Mortgage A: $970 a month for 30 years Mortgage B: $760 a month for 5 years and $1,005 for 25 years 1.1 20 far $120.000 storts ot 4.01

Company ABC is offered a 1-year loan of $50,000 from Bank DEF. The nominal interest rate is 12%p.a. and interest is to be paid at the beginning of the loan.   Question 17 options:   1)  The effective interest rate of the loan will be 12.00%p.a.   2)  The effective interest rate of the loan will be 10.71%p.a.   3)  The effective interest rate of the loan will be 13.64%p.a.   4)  There is insufficient information to determine the effective interest rate.

I need the excel function typed out? Example =RATE???? G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate!                             INPUTS:     OUTPUT:           Period   27 Rate is   APR       Payment   2229.45             Loan amount   358000

Calculation need to be done in "Excel format"

Subject:

Subject:- finance

You have taken out a $7,500,000 loan with a 4% interest rate, 30 year amortization and ten year term. What is the loan balance after the final loan payment? a. $0 b. $7,390,303 c. Cannot determine with information provided d. $5,908,797

6

Suppose bank a offers a 229020 year 6.4% fixed rate mortgage with closing cost of 2600 + 4 points what are their closing costs associated with this mortgage