Equity bank grants you a loan of 49,800 on 1 january 2022 that is repayable in 5 annual payments of 13815 at an Interest rate of 12% per annum. Construct arnortization schedule using excel and calculate total interest?
Q: Which of the following information is useful to test semi-strong form efficiency? Group of answer…
A: Semi strong form of Efficient market advocates for complete discounting of the public information…
Q: What is the future value of a $830 annuity payment over six years if interest rates are 10 percent?…
A: We will use the below formula to calculate the future value Future value = P*[(1+r)n-1]/r Where P…
Q: If the bank decides to cut down on interest expenses by reducing its dependence upon borrowed funds,…
A: We have to figure out the policy the bank must follow if it decides to cut down on interest expenses…
Q: Can you provide a manual written working of calculating covariance with MP? I am very much still…
A: Formula for covariance is: Covariance(XY)=∑P*(X-X) *(Y-Y) Where P=Probability X⇀ = Average of the…
Q: Your firm is considering an expansion project that requires a fixed asset investment of $2.5 million…
A: Net present value (NPV): The net present value is a technique used for making the investment…
Q: he Face Value of a Bond is £1000, the Maturity is 4 years, Yield is 3%, the Frequency of yield is…
A: The price of bond is the present value of coupon payment and present value of par value of bond…
Q: Which one is not an assumption of a perfect capital market? No taxes No dividend distribution No…
A: In "perfect capital markets," no buyer or seller (or issuer) of securities is substantial enough for…
Q: Compute the present value of an $1,200 payment made in 9 years when the discount rate is 11 percent.…
A: Future value (FV) = $1,200 Discount rate (r) = 0.11 Period (n) = 9 years Present value = ?
Q: Orbital Milling Services is going toreplace one of its new 3-D prototyp- ing systems. High use in…
A: IRR decision rule The capital project should be accepted only if its IRR is more than the cost of…
Q: A project has the following cash flow Year Cash flow 0 -10600 1…
A: MIRR refers to modified internal rate of return. The objective of MIRR is to overcome the…
Q: QUESTION 8 Auto Loans R Them loans your $24,000 for four years to buy a car. The loan must be repaid…
A: Annual payments or periodic payments on a loan can be calculated using the PMT Function in excel.…
Q: ear 0 1 2 Expected net cash flow ($100,000) $70,000 $50,000 ative a. b. C.
A: Payback period is one of simple capital budgeting methods that are being used and it is calculated…
Q: What annual interest rate would you need to earn if you wanted a $600 per month contribution to grow…
A: The yearly rate of return technique, often known as the annual percentage rate, calculates the…
Q: Tribbles-R-Us has 200,000 shares outstanding and just paid a $0.25 per share dividend. The market…
A: Solution: Capital Asset Pricing Model (CAPM) is a model which gives a formula to calculate the…
Q: An asset costs R6 300,000 with a R900,000 salvage value at the end of its ten-year life. If annual…
A: Payback period is one of the simple method of capital budegting techniques and it is the time…
Q: What would be the cost of retained earnings equity for Zola Mining if the expected return on S.A.…
A: The Capital asset pricing model can be used to calculate the cost of retained earnings. Cost of…
Q: Based upon the following cash flows, Using IRR should Famous Al’s Cookie Company introduce a new…
A: Solution:- Internal Rate of Return (IRR) is the rate of return the project is yielding. It can be…
Q: Hank purchased a car for $23,500 two years ago using a 4-year loan with an interest rate of 6.0…
A: Data given: Loan amount=$23500 Interest rate=6% N=4 years Required: Minimum price required for the…
Q: The firm can raise an unlimited amount of debt by selling R1,000 par value, 8% coupon interest rate,…
A: Bonds are long term sources of finance for the company and it is very low cost method because after…
Q: t value of an annuity Determine the present value of $200,000 to be received at the end of each of…
A: Present value of annuity is equivalent amount that must be invested today based on the interest rate…
Q: If you invest £100 now and expect to receive £133.1 in 2 years time, what is the Internal Rate of…
A: Note: In Option, a) 0 is being used instead of the bracket, and accordingly it is 15% and not…
Q: is expected to return 20% percent in a boom, 10% percent in a normal economy, and lose 2 percent in…
A: Standard deviation is the measure of the total risk of the stock and it shows that how much the…
Q: The firm’s common stock is currently selling for R95 per share. The firm expects to pay cash…
A: Current Selling Price of Common Stock = R95 Cash Dividends = R10 per share Constant Growth rate =…
Q: V1 Your firm is considering a project that requires a $500,000 investment in fixed assets. These…
A: When the project appraisal criteria is NPV, if NPV is positive, the project should be accepted while…
Q: You have decided to get a $5,000,000 balloon mortgage with the following characteristics: 5 years…
A: Here, Particulars Values Loan Amount (PV) $5000000.00 Interest rate 10.00% Ballon payment…
Q: A firm has the balance sheet accounts, common stock, and paid-in capital in excess of par, with…
A: When the shares are sold for more than its face value, the excess is credit to "Paid in capital in…
Q: . Your firm is considering a new office complex. Your firm already owns land suitable for the new…
A: Land value increase with time and there is no depreciation in the land but there is appreciation in…
Q: ABC Co. and XYZ Co. are identical firms in all respects except for their capital structure. ABC is…
A: We have to apply the MM hypothesis and propositions illustrating the principles that in the absence…
Q: Lindsay is 25 years old and has a new job in web development. She wants to make sure that she is…
A: Given Yearly payment is $12000 Rate is 7%
Q: EA 1. LO 12.1 Campus Flights takes out a bank loan in the amount of $200,500 on March 1. The terms…
A: When an amount is borrowed, with the agreement to repay in fixed installments or lump-sum payments…
Q: Which of the following statements are true? I At higher discount rate, a project is more likely to…
A: IRR is internal rate of return at which net present value is and present value of cash flow is equal…
Q: Lifeline, Inc., has sales of $928,589, costs of $498,849, depreciation expense of $62,374, interest…
A: Solution:- Net profit means the net earnings earned by a firm after taking into consideration the…
Q: Ms. Smith agreed to purchase a property for $400,000 under the following terms: 80 percent…
A: We have a home loan amortization problem. We have to find the outstanding balance at the end of year…
Q: 4 eBook Print References Drill Problem 10-9 (Static) [LU 10-1 (2)] Complete the following, using…
A: Solution: An amount borrowed has to be paid along with interest. As per exact method, Interest…
Q: ur investment is growing at 20%, how would you calculate how long it would take to double in size?…
A: The future value of money is amount being deposited and amount of interest being accumulated over…
Q: Complete the following (If more than one discount, assume date of last discount): (Use Table 7.1)…
A: Trade discounts are provided to encourage early and timely payments. 2/10 indicates that if payments…
Q: A premium bond is purchased to yield 4% convertible semiannually. The amount of premium amortized in…
A: Bond Amortization The amortization of excess premium paid over and above the face value of the Bond…
Q: A $1000 par value 9% bond with semiannually coupons is callable 6 years after issue. The bond…
A: Par Value = $1,000 Coupon Rate = 9% Yield = 4% Time Period = 10 Years Callable = 6 Years
Q: A 1000 par value 18-year bond with annual coupons is bought to yield an annual effective rate of 5%.…
A: Bond refers to the instrument that represents the loan taken by a borrower by an investor including…
Q: What is the NPV for the following project if its cost of capital is 15 percent and its initial…
A: NPV is the differential of present value of all cash inflows and cash outflows. If NPV is positive,…
Q: The price of a condominium is $190,000. The va requires 5% down payment in one point at the time of…
A: Mortgage refers to the loan amount that is taken by the borrower from the lender in exchange for…
Q: You are comparing Stock A to Stock B. Given the following information, what is the difference in the…
A: Expected rate is mean rate of return considering the different scenario and probability of different…
Q: Holtzman Clothiers's stock currently sells for $19.00 a share. It just paid a dividend of $2.50 a…
A: Compute the stock price at the end of year 1, using the equation as shown below: Stock price=Current…
Q: 1)What would be the unlevered beta of Simon So CFO's suggestion? 2) What would be new beta…
A: Please note that as per the guidelines I am required to answer only the first 3 questions. Beta…
Q: ashions recently paid a R2 annual dividend. The company is projecting that its dividends will grow…
A: The value of stock can be found out based on the two stage dividend growth model and one is variable…
Q: Solving for Rates What annual rate of return is earned on a $2,600 investment when it grows to…
A: Initial amount (I) = $2,600 Future value (FV) = $5,700 Period (n) = 9 Years Annual rate of return…
Q: 1. A French Investor buys AAPL stock at the beginning of the year for $150 dollars. He had Euros but…
A: Here the rates are quoted as USD.EUR. This means that the value provided is value of 1 USD in Euro…
Q: Weston Corporation just paid a dividend of $3.75 a share (i.e., Do = $3.75). The dividend is…
A: Compute the dividend at the end of year 1, using the equation as shown below: Dividend=Just paid…
Q: .(True or False) Risk shifting refers to a situation in which management of a firm with risky debt…
A: Risk Risk The chance of loss in an investment or the uncertainties involved in an investment is…
Q: Determine the project's NPV if the Profitability Index is 0.4; and the investment value is $500,000.…
A: Net present value(NPV) of the project is calculated using following equation Profitability index =…
Equity bank grants you a loan of 49,800 on 1 january 2022 that is repayable in 5 annual payments of 13815 at an Interest rate of 12% per annum. Construct arnortization schedule using excel and calculate total interest?
Step by step
Solved in 3 steps with 1 images
- All In Digital Bank granted a loan to a client on January 1, 2022. The interest on the loan is 10% payable annually starting December 31, 2022. The loan matures in three years on December 31, 2024. Pertinent information on the loan is provided below: Principal amount, P 1,000,000 Origination fee received from the borrower, P 55,200 Direct origination cost paid, P 30,770 Indirect origination cost paid, P 5,000 After considering the origination fee received from the borrower and the direct origination cost incurred, the effective rate on the loan is 11%. What is the carrying value of the loan receivable on December 31, 2023 in Megabank's accounting books?All In Digital Bank granted a loan to a client on January 1, 2022. The interest on the loan is 10% payable annually starting December 31, 2022. The loan matures in three years on December 31, 2024. Pertinent information on the loan is provided below: Principal amount, P 1,000,000 Origination fee received from the borrower, P 55,200 Direct origination cost paid, P 30,770 Indirect origination cost paid, P 5,000 After considering the origination fee received from the borrower and the direct origination cost incurred, the effective rate on the loan is 11%. At what amount shall the loan be initially measured on January 1, 2022?Compute the amount of interest on $8350 at 6.5% p.a. from October 8, 2019, to August 4, 2020. What rate of interest is paid if the interest on a loan of $12500 is $196.06 from November 14, 2019, to May 20, 2020? Loan payments of $1725 due today, $510 due in 75 days, and $655 due in 323 days are to be combined into a single payment to be made 115 days from now. What is that single payment if money is worth 8.5% p.a. and the focal date is 115 days from now? What principal will earn $355.99 interest at 9.75% p.a. from February 4, 2017, to July 6, 2017? Determine the face value of a four-month promissory note dated May 20, 2018, with interest at 7.5% p.a. if the maturity value of the note is $1190.03. A Company sells locks for $10 each. Manufacturing cost is $2.60 per lock; marketing costs are $2.40 per lock; and royalty payments are 20% of the selling price. The fixed cost of preparing the lock is $18 000. Capacity is 15,000 locks. Compute the contribution…
- You apply for a loan of $151,000 with the following terms: A 7-year loan with semi-annual payments of $14,800 (paid at the end of each period). Based on this information, what is the APR of this loan? (Note: All answers are rounded to two decimals) 4.53% 4.82% 8.42% 9.06% 8.78%Compute the size of the final payment for the following loan. Principal $ Periodic Payment $ Payment Period Payment Made at: Interest Rate % Compounding Period 8100 520 3 months beginning 8 quarterly The size of the final payment is $_ .?complete this activity on a sheet of paper and attach to this activity. elow, you may use either method when calculating the 1. Study the information below and answer the questions that following questions. Capital amount: 30 000 Interest rate: 10% p.a Installments: R1 350 Repayment period: 24 months Calculate interest payable for the full 2 year period using the simple methoc a. b. Calculate the total interest payable for the first six month using the compound method. 2. Study the information below and answer the questions that following questions Capital amount: R25 000 13% p.a Interest rate: R750 Installments: Repayment period: 36 months Calculate interest payable for the full 36 month period using the simple method Calculate the total interest payable for the first three months using the compound methor a. b. 3. Calculate the interest for the following loan using both simple and compound interest. R400 000 anital amoụnt:
- A customer takes out a loan of $130,000 on January 1, with a maturity date of 36 months, and an annual interest rate of 11%. If 6 months have passed since note establishment, what would be the recorded interest figure at that time? A. $7,150 B. $65,000 C. $14,300 D. $2,383Debt payments of $800.00 due now and $1400.00 due in five months are to be repaid by a payment of $1000.00 in three months and a final payment in eight months. Calculate the size of the final payment if interest is 6%. Select one: a. $1228 b. $1100 c. $2238 d. $1450 O OThe following loan was paid in full before its due date a) Find the value of h using an appropriate formula b) Use the actuarial method to find the amount of unearned interest c) Find the payoff amount Regular Monthly Payment # of Payments Remaining after Payoff APR 7.2% $247 8 What is the finance charge per $100 financed? h=$ (Round to the nearest cent)
- For items 1 to 2 China Bank granted a loan to a borrower on January 1, 2023. The interest rate on the loan is 10% payable annually starting December 31, 2023. The loan matures in five years on December 31, 2027. The data related to the loan are: Principal amount Direct loan origination cost Indirect loan origination cost Origination fee received from borrower P4,000,000 104,410 72,880 526,450 Note: Round-off to four decimal places the PV Factors. The effective interest rate of the loan is? (Round off answer to nearest whole number, e.g. 4%)Consider a credit card with a balance of $7000. You wish to pay off the credit card in each scenario. Calculate the following. Round your answer to the nearest cent, if necessary.a. The amount of a monthly payment within the time frame givenb. The total amount paid over the time period12. APR of 17.99% paid off within 1 year APR of 24% paid off within 3 yearsYou have asked Raider Bank for a $20,000 signature loan, where you will be charged 1% per month informs you that the terms of the loan requires you to make monthly payments. What is the Excel F your daily payments that will be drawn from your account automatically? 200/12 PUNTO 145 and 200001