Exercise #6

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

question on the pic

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) $

Amortization schedule                       Loan amount to be repaid (PV) $25,000.00         Interest rate  (r) 11.00%         Length of loan (in years) 3                     a.  Setting up amortization table   Formula       Calculation of loan payment   #N/A                   Year Beginning Balance Payment Interest Repayment of Principal Remaining Balance 1           2           3                       b.  Calculating % of Payment Representing Interest and Principal for Each Year           Year Payment % Representing Interest Payment % Representing Principal Check:  Total = 100%     1           2           3                       Formulas           Year Beginning Balance Payment Interest Repayment of Principal Remaining Balance 1 #N/A #N/A #N/A #N/A #N/A 2 #N/A #N/A #N/A #N/A #N/A 3 #N/A #N/A #N/A #N/A #N/A             b.  Calculating % of Payment Representing Interest and Principal for Each Year           Year Payment %…

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…

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

Answer? ? Financial accounting question

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

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.

Question 1: Part A.  The current 10 year treasury note is approaching the important threshold of: a) 2.75% b) 2.95% c) 3.25% d) 2.0%   Part B.  In a real estate investment, you may want to obtain a mortgage. In so doing, which year would you expect to see the highest amount of principal pay-down (in a payment mix of principal and interest)? a) year 15 b) year 20 c) year 10 d) year 25Part C.  In a Fast Market, you would rather sell a stock using a: a) Market Order b) Market On Close Order c) Limit Order d) Market On Open OrderPart D. Given that equity markets are asymmetric in their respective moves, markets are said to take________________________  a) the slow grind higher into perpetuity b) the stairs down and the elevator up c) the stairs up and your mom home d) the stairs up and the elevator down     Part E. It is said that traders have come to employ the use of technical analysis potentially for all of the following reasons except:…

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