Please help me with my homework. Thanks! Please make an amortization schedule using the format I put in the image below—a minimum of 12 periods.Note: I attached an example of the amortization schedule below. Please create one with the same format with a minimum of 12 periods. Thanks! Period123456TOTALSAmortization ScheduleOutstandingprincipal (OP)P 50004,283.193523.372717.961,864.23959.27Interest due at endof period (OP x i)P 300256.99211.40163.08111.8557.55P 1,100.871=0-06A = 101681Payment (A)P 1,016.811,016.811,016.811,016.811,016.811,016.81P 6,100.86Principal repaid atend of period (A-1)P 716.81759.82805.41853.73904.96959.27P 5,000.00

An amortization schedule with a minimum of 12 periods with a loan amount of P11000 and an interest…

Please help me with my homework. Thanks! Please make an amortization schedule using the format I put in the image below—a minimum of 12 periods. Note: I attached an example of the amortization schedule below. Please create one with the same format with a minimum of 12 periods. Thanks!

Please help me with my homework. Thanks! Please make an amortization schedule using the format I put in the image below—a minimum of 12 periods. Note: I attached an example of the amortization schedule below. Please create one with the same format with a minimum of 12 periods. Thanks!

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: Q.3Determine the risk-neutral value for a European put option (for a FLB (First Local Bank) share)…

A: Information Provided: Period of expiration = 8 months Strike price = 500 Current price = 650…

Q: A stock is worth $50 on december, 1st 2021. This price increases by 4% ou decreases by 4% every 2…

A: The strike price of an option is the predetermined price at which the option's owner may purchase or…

Q: pute the PI statistic for Project X and note whether the firm should accept or reject the project…

A: PI is the profitability index and it is ratio present value of the positive cash flow to the present…

Q: reservation point?

A: Reservation point is the minimum point which the party will accept a agreement. It is always denoted…

Q: Over the past six months, NTFLX has prices: Date Close Price 5/1/2022 197.44 6/1/2022 174.87…

A: Geometric Mean =[ ( X1 * X2 *....Xn)(1/n) ] -1 Where X1 = return of first period X2 = return of…

Q: Using the CAPM theory, if the Volatility of a stock is twice as great as the market, the market…

A: Capital Asset Pricing Model (CAPM) is used to determine expected return on a particular security…

Q: Robert Campbell and Carol Morris are senior vice-presidents of the Mutual of Chicago Insurance…

A: 1. Par value bond is the amount borrowed by the issuer and repays the amount borrowed at Maturity at…

Q: How much will a $100 deposit made today be worth in 10 years if interest is compounded quarterly at…

A: Future value of the deposit includes the amount being deposited and amount of interest accumulated…

Q: Wells Fargo gives you an offer of $450,000 at a mortgage rate 5.5%, compounded quarterly. Citi Bank…

Q: Suppose you have been requested to evaluate a solar farm investment in Warwick. The investment cost…

A: The Net Present Value and the Internal Rate of Return: The Net Present Value: The net present value…

Q: 3. Company A's callable bonds have a face value of $1,000 with 6% coupon rate (semi-annual payment)…

A: A bond has been provided with all the details. We have to find the yield to call (YTC) and then…

Q: What is the expected annual return over four years for the second strategy? Information from prior:…

A: Second Strategy Interest rate on 1 year first purchased bond "R1" is 8% Interest rate on 1 year…

Q: Which of the following statements is false? AAA-rated bonds have a lower probability of default…

A: 1) AAA credit rating is the top notch rating. Securities with AAA credit rating have highest degree…

Q: Please explain why this statement is (False). If a security's realized return is negative, it must…

A: The realized return of the security is the return that the security has provided in the past. The…

Q: Compute how much interest a company would pay in 2023 on a 10 year, $100,000+u dollar loan (which it…

A: We have to find the interest payable on a 10 year dollar loan that has a variable rate of interest.…

Q: A man will deposit P1,000.00 with a savings and loan association at the beginning of each 3 months…

A: Quarterly deposit refers to the amount to be paid at each quarter until the whole repayment of…

Q: A. Explain and illustrate the interaction between firms and households

A: As per Bartleby guidelines, If multiple questions are posted, only the first 1 question will be…

Q: If $100 is deposited in a fund at the beginning of each 3 months for 8 years and the money is…

A: Quarterly deposit (C) = $100 Quarterly interest rate (r) = 0.0125 (i.e. 0.05 / 4) a. Number of…

Q: If the future value of an ordinary, 5-year annuity is $6,000 and interest rates are 8 percent,…

A: Money received or paid out today is worth more than the same amount of money in the future because…

Q: As a consultant hired by Tom Plc, in analyzing a change in policy, you wish to campaign for a…

A: A change in policy is leading a perpetual improvement in daily value of $ 100. We have to comment…

Q: A newly issued 10-year, $1,000, zero coupon bond just sold for $311.05. What is the implicit…

A: Data given: FV=$1000 n=10 year PV= $311.05 Interest is semiannual compounding.

Q: Cori's Corporation has a book value of equity of $13,380. Long-term debt is $8,550. Net working…

A: As per acounting principle, Total Assets = Total liabilities + Shareholders' equity Fixed Assets +…

Q: behavioural factors influencing investment decision making

A: Investment decisions are made by investors and investment managers. These decisions are made based…

Q: Yesterday at the market close, the stock of Kevin Spellman, Inc. was trading at $100 per share and…

A: Solution:- Stock split means the splitting of existing number of shares to multiple parts, i.e. each…

Q: If a preferred stock from Ecology and Environment, Inc. (EEI) pays $8.50 in annual dividends, and…

A: Dividend - This is the amount which is paid by the company to its shareholders. Dividend includes…

Q: Tom creates a 30-year mortgage of $150,000 with APR 5.6%, monthly paid. Please find the balance at…

A: Loan amount (P) = $150,000 Monthly interest rate (r) = 0.00466666666666667 (i.e. 0.056 / 12) Monthly…

Q: Solve the following: USE 4 DECIMAL PLACES Nominal Rate 5% compounded semi annually 5% compounded…

A: Equivalent interest rates are interest rates that produce the same return as the given annual…

Q: You are evaluating a company's stock. The stock just paid a dividend of $1.75. Dividends are…

A: The Fair present value of stock is calculated by Gorden's Model. As per Gorden's Model the price of…

Q: If a stock has a higher volatility, would your broker would want to set the maintenance margin…

A: Maintenance margin is minimum margin amount that we need to maintain as an investor after the…

Q: Bloom Company Limited expects its EBIT to be $80,000 every year forever. The firm can borrow at 9…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: Determine how much is her maximum loanable amount using the Fixed obligation to income ratio. Show…

A: First let us list the formula to calculate the Fixed Obligation to Income Ratio.FOIR = Loan…

Q: The earnings and dividends of Ned Computer Co. are expected to grow at an annual rate of 15 percent…

A: The concepts of dividend discount model will be used here. As per the dividend discount model the…

Q: ABC Limited is an all-equity firm and has a present capital structure of 10 million shares of common…

A: Breakeven EBIT is the level of Earnings Before Interest and Tax (EBIT) wheere the Earnings per share…

Q: information on its 2015 income statement: Sales = $215,000; COGS= $117,000; o Other operating…

A: Cash Flow Statement is the Statement of cash receipts and cash payments for the period. There are…

Q: A lender is considering what terms to allow on a loan. Current market terms are 9 percent interest…

A: Data given: Loan = $97,850 Interest rate=9% Amortization year=25 Required: Origination fee to be…

Q: What is the implicit tax rate that the individual who has earned income of $19,000 faces?

A: Implicit tax rate is the rate which we will levy on the value of the asset. It is also known as…

Q: Complete the following, using ordinary interest. (Use Days in a year table.) Note: Do not round…

A: Maturity value The value an investor receives by holding a security for a specific period of time is…

Q: Please expalin why this statement is (True). The traditional liquidity premium theory states that…

A: Liquidity Premium Liquidity premiums are additional compensation added to investors who invest in…

Q: Frank's Used Cars has sales of $860316, total assets of $670249, and a profit margin of 0.12. The…

A: Information Provided: Sales = $860,316 Total assets = $670,249 Profit margin = 0.12 Equity…

Q: Question b) Describe the yield curve that is constructed from the results in part (a) Question c)…

A: Given: Year Inflation rate Maturity risk premium Maximum Maturity risk premium Real risk free…

Q: Find the accumulated value of an investment of $20,000 for 5 years at an interest rate of 4.5% if…

A: Initial investment (I) = $20,000 Interest rate = 0.045 Accumulated value is the compounded value…

Q: Jenna bought a bond that was issued by Sherlock Watson Industries (SWI) three years ago. The bond…

A: Par Value is $1,000 Coupon rate is 9% Maturity is 17 years Jenna bought 3 years ago James bought two…

Q: You invest $9000 in an account that pays simple interest of 2% for 13 years. What is the interest…

A: Simple interest The method used to calculate interest on an amount charged or paid at a specified…

Q: Part A. The current 10 year treasury note is approaching the important threshold of: a) 2.75% b)…

A: Since you have posted multiple question , we will solve first question for you. If you want any…

Q: An insurance company is expected to pay out $300 million in 5 years’ time. Which of the following is…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Critically evaluate how the Representativeness heuristic influences investment decision-making.

A: Investment The process of investing money with an aim of obtaining a profit or gain is known as…

Q: You answer is not one of my options: 58.74 %; accept 48.17 %; reject 8.00 %; accept 47.21 %;…

A: The profitability index is calculated by dividing the present value of future cash flows flows that…

Q: Company X’s had cash flows for the year as follows ($ in millions): CASH RECEIVED FROM:…

A: Cash flow from operating activities consists of cash inflows and cash outflows from day to day…

Q: Which of the following is not a dominant risk that might affect the price of a bond? A Deferred…

A: Bond is a fixed income instrument. Bond represent a loan made to corporate and government in return…

Q: A bond has a Modified Duration of 11 years, and a current yield to maturity of 8% with semi-annual…

A: “Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only…

Question

Please help me with my homework. Thanks!

Please make an amortization schedule using the format I put in the image below—a minimum of 12 periods.

Note: I attached an example of the amortization schedule below. Please create one with the same format with a minimum of 12 periods. Thanks!

Period
1
2
3
4
5
6
TOTALS
Amortization Schedule
Outstanding
principal (OP)
P 5000
4,283.19
3523.37
2717.96
1,864.23
959.27
Interest due at end
of period (OP x i)
P 300
256.99
211.40
163.08
111.85
57.55
P 1,100.87
1=0-06
A = 101681
Payment (A)
P 1,016.81
1,016.81
1,016.81
1,016.81
1,016.81
1,016.81
P 6,100.86
Principal repaid at
end of period (A-1)
P 716.81
759.82
805.41
853.73
904.96
959.27
P 5,000.00

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1 Given

VIEW

Step 2 Solution

VIEW

Step 3 Final answer

VIEW

Step by step

Solved in 3 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

See image. Choices: a. P780,000 b. P720,000 c. P1,440,000 d. P560,000
Substitute the value for the number of compounding periods. PMT =$96,500[(0.003267)/(1-(1+0.003267)^(-168))]
A. P178,000B. P193,000C. P200,000D. P207,000E. Answer not given
See image. CHOICES:a. P905,000 b. P895,000 c. P915,000 d. P900,000
Question Content Area Present value of $1 Periods 6% 8% 10% 12% 14% 16% 1 0.94340 0.92593 0.90909 0.89286 0.87719 0.86207 2 0.89000 0.85734 0.82645 0.79719 0.76947 0.74316 3 0.83962 0.79383 0.75131 0.71178 0.67497 0.64066 4 0.79209 0.73503 0.68301 0.63552 0.59208 0.55229 5 0.74726 0.68058 0.62092 0.56743 0.51937 0.47611 6 0.70496 0.63017 0.56447 0.50663 0.45559 0.41044 7 0.66506 0.58349 0.51316 0.45235 0.39964 0.35383 8 0.62741 0.54027 0.46651 0.40388 0.35056 0.30503 9 0.59190 0.50025 0.42410 0.36061 0.30751 0.26295 10 0.55839 0.46319 0.38554 0.32197 0.26974 0.22668 Present value of an annuity of $1 Periods 6% 8% 10% 12% 14% 16% 1 0.94340 0.92593 0.90909 0.89286 0.87719 0.86207 2 1.83339 1.78326 1.73554 1.69005 1.64666 0.74316 3 2.67301 2.57710 2.48685 2.40183 2.32163 0.64066 4 3.46511 3.31213 3.16987 3.03735 2.91371 0.55229 5 4.21236 3.99271 3.79079 3.60478 3.43308 0.47611 6 4.91732 4.62288 4.35526 4.11141 3.88867 0.41044 7 5.58238 5.20637…
A=2000 for period 3 to 10, i=5% (compounded per period) find the present value of this uniform series at t=1 ( i. e P1=? ) A) 12,926.4 B) 12,310.8 C) 11,942.6 D) 11,161.3 E) 11,716.6
choices: P415,000 P370,000 P380,000 P460,000
59. Question: In conformity with the revenue test, what is the total revenue of the reportable segments? CHOICES: P51,000 P52,000 P71,000 P60,000
ASiithial 10) eymarta) o px s yous i odcoon, you wh o o axcumiiod $140008 s v O PAS Todots ) s o yob 1 b Wil 0oy Y3 scnconpoune o, o 15 Y W-ﬂmmmmmﬂmnmhmmmmbmmmmn“ (Round 19 the nerest cont) .
A. P630,000 B. P525,000 C. P1,050,000 D. P0
Present and future values of $1 at 3% are presented below: N FV $1 PV $1 FVA $1 PVA $1 FVAD $1 PVAD $1 1 1.03000 0.97087 1.0000 0.97087 1.0300 1.00000 2 1.06090 0.94260 2.0300 1.91347 2.0909 1.97087 3 1.09273 0.91514 3.0909 2.82861 3.1836 2.91347 4 1.12551 0.88849 4.1836 3.71710 4.3091 3.82861 5 1.15927 0.86261 5.3091 4.57971 5.4684 4.71710 6 1.19405 0.83748 6.4684 5.41719 6.6625 5.57971 7 1.22987 0.81309 7.6625 6.23028 7.8923 6.41719 8 1.26677 0.78941 8.8923 7.01969 9.1591 7.23028 9 1.30477 0.76642 10.1591 7.78611 10.4639 8.01969 10 1.34392 0.74409 11.4639 8.53020 11.8078 8.78611 11 1.38423 0.72242 12.8078 9.25262 13.1920 9.53020 12 1.42576 0.70138 14.1920 9.95400 14.6178 10.25262 13 1.46853 0.68095 15.6178 10.63496 16.0863 10.95400 14 1.51259 0.66112 17.0863 11.29607 17.5989 11.63496 15 1.55797 0.64186 18.5989 11.93794 19.1569 12.29607 16 1.60471 0.62317 20.1569 12.56110 20.7616 12.93794 Debbie has $368,882 accumulated in a 401K plan. The fund…
Present and future values of $1 at 3% are presented below: N FV $1 PV $1 FVA $1 PVA $1 FVAD $1 PVAD $1 1 1.03000 0.97087 1.0000 0.97087 1.0300 1.00000 2 1.06090 0.94260 2.0300 1.91347 2.0909 1.97087 3 1.09273 0.91514 3.0909 2.82861 3.1836 2.91347 4 1.12551 0.88849 4.1836 3.71710 4.3091 3.82861 5 1.15927 0.86261 5.3091 4.57971 5.4684 4.71710 6 1.19405 0.83748 6.4684 5.41719 6.6625 5.57971 7 1.22987 0.81309 7.6625 6.23028 7.8923 6.41719 8 1.26677 0.78941 8.8923 7.01969 9.1591 7.23028 9 1.30477 0.76642 10.1591 7.78611 10.4639 8.01969 10 1.34392 0.74409 11.4639 8.53020 11.8078 8.78611 11 1.38423 0.72242 12.8078 9.25262 13.1920 9.53020 12 1.42576 0.70138 14.1920 9.95400 14.6178 10.25262 13 1.46853 0.68095 15.6178 10.63496 16.0863 10.95400 14 1.51259 0.66112 17.0863 11.29607 17.5989 11.63496 15 1.55797 0.64186 18.5989 11.93794 19.1569 12.29607 16 1.60471 0.62317 20.1569 12.56110 20.7616 12.93794 Rosie's Florist borrows $300,000 to be paid off in six…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS