A lender providing a loan of S5.5 million requires semi-annual payment of interest at a nominal rate of 7.9% p year, and repayment of the $5.5 million principal at the end of 8 years. The borrower plans to accumulate th principal for repayment at the end of 8 years using level semi-annual deposits into a sinking fund that earn interest at a nominal rate of 4% per year when compounded semiannually. What is the borrower's total cas outlay every 6 months?

Q: where  is the excel sheet ,so i can see how you get  the answer.  I want to see the workings  please

A: Excel Workings are provided in the solution in the form of Excel snip. One can use the formula…

Q: will you please show solution without excel step by step

A: As per the given information: Initial salary is $40,000 Salary rise after first year to $44,200…

Q: Can you please step this out line by line (not all in one line) and state the formula used

A: The concept of time value of money states that worth of money changes with passage of time. This is…

Q: Which of the following is true of structured data? Select answer from the options below Structured…

A: The objective of the question is to identify the correct statement about structured data from the…

Q: 2.3-2.4 (Excel): You have been offered a unique investment opportunity. If you invest $1 million at…

A: Net present value of investment is the difference between present value of inflows and outflows.…

Q: What does internal rate of return (IRR) help you to determine

A: Internal Rate of Return (IRR) is a financial metric used to evaluate potential profitability of an…

Q: how do you calculate this question with excel formulas

A: Information Provided: Withdraw amount = $10,000 Interest rate = 6% Years for withdraw $10,000 = 5…

Q: CAN YOU SHOW THE STEPS ON A BA CALCULATOR USING THE PMT + I/Y + FV BUTTONS.....I CAN GET THE LONG…

A: Given: Payment = $250 Interest rate = 8% Future value (FV) = $50,000

Q: please display your formula used in your work

A: Monthly payment refers to the payment amount for the loan grounded on the constant payments as well…

Q: IFRS16 allows lessees not to recognise a right-of-use asset or a lease liability for certain types…

A: The right-of-use asset is a lessee's right to use an asset over the life of a lease. It is recorded…

Q: Which ways can a decision tree be presented to help lay out the sequence of decisions that can be…

A: Graphical representation:- In this format, nodes and branches are used to visually represent the…

Q: hi, can you please show me how to solve this without using excel? thank you

A: Variables in the question:Interest rate = 3.75% per year compounded quarterlyQuarterly means 4 times…

Q: 7. The ultimate control of the corporation rests with the board of directors.

A: Introduction:- Board of directors:- Board of directors play vital role in every organization for…

Q: On 1 January 2019, a company which prepares financial statements to 31 December each year, enters…

A: The right-of-use asset is a lessee's right to use an asset over the life of a lease. It is recorded…

Q: Using Ai leads to downvote 10. Explain the concept of truth tables in logic design.

A: A truth table is a mathematical table that is used in logic design to show the functional values of…

Q: Can you solve using excel and explain the formulas more in depth?

A: Here,Market Cap is 300 billion pesoNext Year FCF is 9.6 billion pesoGrowth Rate is 8.60%

Q: What formula is being used if not using excel?

A: The concept of the time value of money determines that the worth of money gets depreciated over a…

Q: Company W acquired a wastewater treatment plant for 30,000, depreciable over 10 years. The company…

A: Government grant means the amount received from government free of cost. It is received by specified…

Q: Would you please express the operations without excel. I need to understand it with the actual…

A: The price of stock can be found as the present value of growing dividend in two stages one is…

Q: Match the two lists, below, by placing the capital letter from List 1 in each of the cells preceding…

A: Control Environment A control environment is made up of the standards, policies, procedures, and…

Q: What is the advantage of selecting the “Only Create Connection" option when importing data?

A: The "Only Create Connection" option in data import typically refers to importing data into a data…

Q: On 31st of July 2023, Dino Plc which has a financial year end at 31st of March bought a bespoke…

A: Expenses means the amount spent for running the business. Fixed assets means the amount spent on…

Q: Can you solve it in an Excel spreadsheet? because something is wrong with the asnwer. tyhank you,

A: Bonds are debt instruments issued by companies.The issuing company pays coupons to the bond holders…

Q: Is it possible to get a solution with formulas instead of excel?

A: Money's value depreciates over time, according to the time value of money idea. This is due to the…

Q: Which of the following statements is TRUE about a scenarios page in a model? Select one: Oa. Answers…

A: The scenario page is about choosing between two machines (A and B) based on a scenario where they…

Amortized Loans

The term "amortization" refers to spreading the value of a loan or a debt over a series of regular payments or installments comprising of both the principal and interest amount. It generally involves the process where in the value of a loan or an intangible asset is written down over its maturity period.