In everyday life, we also have quite a lot of financial decisions to make. I thank you for reading and hope to see you on our blog next week! Anybody who experiences it, is bound to love it! As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Reason: When calculating monthly or quarterly payments, you forgot to convert the number of years to the total number of payment periods. Solution: Effective Interest Rate is calculated using the formula given below. Our reference document throughout is the BCBS January 2016 publication “Minimum Capital Requirements for Market Risk.” Having previously implemented the ISDA SIMM IM models in Excel, the similarities are striking for the Interest Rate portion of risk. RATE is an Excel financial function that finds an interest rate per a given period of an annuity. It is a powerful tool used to determine the outcome of your investments. For this, you just need to supply an appropriate number of payment periods to the RATE function. Figure 4 – Rate standard deviation Now calculate Rate VaR using the standard Value at risk formula. The other two optional arguments [fv] and [guess] are also omitted. Most often, this happens because positive numbers are used to represent outgoing cash flows. It is like having an expert at my shoulder helping me…, Your software really helps make my job easier. Create interest rate calculator in Excel. Because the formula cell is formatted to show no decimal places, the displayed value is "rounded" to zero. Financial decisions are an important element of business strategy and planning. For example, during a recession, interest rate will be cut to kick-start the economy. Effective Interest Rate = 10.25%. ... ExcelIsFun, the 54th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate interest rate risk or IRR. The formula to calculate simple interest is: interest = (principal) × (interest rate) × (term) This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets. In this example, we want to calculate the interest rate for $5000 loan, and with 60 payments of $93.22 each. The 200+ Best, Hidden & Most Powerful Features & Changes for iPhone, 22 Things You Need to Know About iOS 14's Newly Redesigned Widgets for iPhone, Best New iOS 14 Home Screen Widgets & The Apps You Need, 13 Exciting New Features in Apple Photos for iOS 14, 9 Ways iOS 14 Improves Siri on Your iPhone, 16 New Apple Maps Features for iPhone in iOS 14, 19 Hidden New Features in iOS 14's Accessibility Menu, Every New Feature iOS 14 Brings to the Home App on Your iPhone. interest rate swap value at risk – indexed dataset. Premium A-to-Z Microsoft Excel Training Bundle, What's New in iOS 14? In the example, this results in a CAPM of 0.132, or 13.2 percent. Annual Interest Rate = 0.62% (monthly interest rate)* 12 (total months in a year) = 7.42%. Reason: The calculated interest rate is less than 1%. The best spent money on software I've ever spent! How will your investment grow in terms of CAGR? Interest = Amount X Rate X Years = 3000 X 10 X 2 = 600. Interest rate risk is mostly associated with fixed-income assets (e.g., bonds Bonds Bonds are fixed-income securities that are issued … How much interest rate risk a bond has depends on how sensitive its price is to interest rate changes in the market. 1. The inflation rate is taken for the tenure for which the investment is made 3. That's how to use RATE function in Excel to calculate interest rate. When posting a question, please be very clear and concise. Since most installment loans are paid monthly, it may be helpful to know a monthly interest rate, right? This time, our goal is to create a universal interest rate calculator for annuity, which is a series of equal payments made at regular intervals. Click Blank Workbook. A demonstration on calculating convexity and using it to estimate the interest rate risk of a bond. Enter this into your spreadsheet in cell A4 as "=A1+(A2_(A3-A1))" to calculate the expected return for your investment. Assuming the payment is due at the end of each month, you can find a monthly interest rate by using the already familiar formula: Compared to the previous example, the difference is only in the values used for the RATE arguments. The interest rate paid in exchange for granting credit reflects the purpose of a loan and the degree of risk your credit score poses to a lender. Suppose the loan is to be paid over 3 years in monthly installments. To get the total number of payment periods, we multiply it by 12. I don't know how to thank you enough for your Excel add-ins. Excel Investment Calculator can calculate compound interest and provide the future value of an investment. Brush up on the stuff for your next or current job with this how-to. Once you have the return series for interest rates, rate VaR uses the EXCEL standard deviation function to calculate the volatility of rates and then apply the VaR parameters to calculate Value at Risk for the relevant interest rate. To find that out, you set up the following arguments for the RATE function: Please pay attention that the pmt argument is not used in this case, so we leave it blank in the formula: As the result, the Excel RATE function tells us that our investment has earned the 14.87% compound annual growth rate over 5 years. To efficiently use RATE formulas in your worksheets, please pay attention to these usage notes: In this example, we'll look at how to make a RATE formula in its simplest form to calculate interest rate in Excel. Time to maturity. We input the variables in corresponding cells like shown in the image below, and enter the following formulas: For our sample data, the results look as follows: The more complex the function, the greater chance of an error. Risk Premium = ra (100,000 x 18 / 100) – rf (100,000 x 3 / 100) = 18,000 – 3000 = 15,000 US$. The RATE function calculates by iteration. Derek owes the bank $120 two years later, $100 for the principal and $20 as interest. To solve this problem, simply apply the Percentage format with two or more decimal places to the cell containing your formula. As you may have noticed, the previous examples focused on solving specific tasks. As the result, we get this simple formula: If it is required that the payment be entered as a positive number, then put the minus sign before the pmt argument directly in the formula: Now that you know the essentials of using RATE in Excel, let's explore a couple of specific use cases. Symptom: The result of your RANK formula is a negative percentage, or much lower or higher than expected. Figure 5 IRS CCS VaR Historical Simulation – Par Rates. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 54th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate interest rate risk or IRR. Microsoft and the Office logos are trademarks or registered trademarks of Microsoft Corporation. Calculate the simple interest on $500 invested at the rate of 6% per annum for 10 years using Excel. Excel Finance Class 54: Bonds & Interest Rate Risk - YouTube It's assumed that the payment is to be made at the end of each year, so we can omit the [type] argument or set it to the default value (0). I love the program, and I can't imagine using Excel without it! Or a periodic interest rate is not converted to an annual interest rate. Solve for the asset return using the CAPM formula: Risk-free rate + (beta_(market return-risk-free rate). Compose your response just once, save it as a template and reuse whenever you want. Calculate risk measures based on the sensitivities per maturity bucket, multiplied with interest rate shifts contained in interest rate risk scenarios. Interest Rate Risk. For instance, you are going to apply for a loan to buy a new car. You can determine how much your money will grow using Excel Investment Calculator. Following on from Amir’s look at FRTB and the different approaches available, I will dig into the numbers to expand on the Standardised Approach for Interest Rate Swaps. You are planning to pay 3 yearly installments of $3,800 each. What will the annual interest rate be? investment(average)*months*interest rate=interest calculation of interest: 2000*5*5%=500 as the customer is supposed to pay in 5 terms of 500 the effective interest is: 7.92% the average investment is then: 500/7.92%/5=1262.63 lets say the actual interest rate (based on real payments) is 6.04% (meaning average capital*months=8278.15) The sensitivity depends on two things, the bond's time to maturity, and the coupon rate of the bond. Let's say you've borrowed $10,000 that should be paid in full over the next three years. Another common scenario is finding an interest rate on a series of periodic cash flows where we know the future value, not the present value. Instead of building formulas or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse click. Systematic risk includes market risk,Market Risk PremiumThe market risk premium is the additional return an investor will receive (or expects to receive) from holding a risky market portfolio instead of risk-free assets. The real rate is calculated as the nominal rate minus the inflation There are two risks that cannot be avoided one is the inflation risk and the other is interest rate risk, both of which are captured in the formula Real rate 4. Then, use the RATE function to calculate the quarterly interest rate (C7): And multiply the result by 4 to get the annual interest rate (C9): In the above examples, we were dealing with loans and calculated the interest rate based on three primary components: loan term, payment amount per period, and loan amount. It's in the upper-left side of the main Excel page. For such scenarios, Excel provides the RATE function that is specially designed for calculating interest rate for a specific period. It will surely be helpful to know exactly what interest rate you will have to pay to your bank. Monthly payments: annual interest rate = RATE() * 12, Quarterly payments: annual interest rate = RATE() * 4. Calculator Rates Microsoft Excel Loan Calculator with Amortization Schedule ... interest rate - the loan's stated APR. With the model setup, we can now use our index numbers and the Excel vlook up function to pick up each complete term structure associated with the relevant index number and feed it to the valuation model. The market risk premium is part of the Capital Asset Pricing Model (CAPM) which analysts and investors use to calculate the acceptable rate interest rate risk, purchasing power risk, and exchange rate risk. Anyone who works with Excel is sure to find their work made easier. Hence, in this case, ABC enjoys a 15,000 US$ risk premium example with this stock investment as compared to the risk-free investment. Supposing you want to invest $100,000 for 5 years and receive $200,000 in the end. Copyright © 2003 - 2020 4Bits Ltd. All rights reserved. Interest Rate Risk Interest rate may go up or down at different points in time for different reasons. Effective Interest Rate = (1 + 10%/2) 2 – 1. The risk-free rate of return can be calculated using the above formula as, =(1+3.25%)/(1+0.90%)-1. As you may have noticed, the previous examples focused on solving specific tasks. No Comments. This will help us provide a quick and relevant solution to your query. This is the real rate that is earned on an investment. To get annual interest rate, we multiply the monthly rate by 12. Interest rate risk is the risk that changes in market interest rates will affect the value of bonds and other debt instruments. The changes in market interest rates may arise due to multiple factors: changes in Federal Reserve policy, movement in yield curve due to overall economic outlook, etc. Interest rate risk is the risk that arises for bond owners from fluctuating interest rates. First, you convert the total number of periods into quarterly: Nper: 3 (years) * 4 (quarters per year) = 12. Please remember to put the minus sign before any amount that is paid out: In some cases, you may need to help the RANK function to converge to a solution by providing an initial guess: When calculating an interest rate with an undefined or zero present value (pv), be certain to specify the future value (fv): Reason: occurs when one or more arguments are non-numeric. RATE is an iterative calculation which means that Excel tries different values until it arrives at a value that best fits the time value of money equation. by Svetlana Cheusheva | updated on December 9, 2020 Excel tool that helps to manage interest rate risk in debt mutual funds The time to maturity and coupon rate are two factors that impact the duration of a bond. He would simply be charged the interest rate twice, once at the end of each year. The risk-free rate formula has two main factors 1. The answer will … RATE = 0.62%. How To: Calculate interest rate risk in Microsoft Excel By getexcellent; 10/26/10 1:00 PM; WonderHowTo. Instructions: This calculator computes the Relative Risk for a 2x2 crosstabulation, which measures the ratio of the risk of developing a condition (or disease) for those exposed to a risk factor, versus the the risk of exhibiting the condition for those that are not exposed to the risk factor. This time, our goal is to create a universal interest rate calculator for annuity, which is a series of equal payments made at regular intervals. To resolve this issue, use the following calculations to express the nper argument in appropriate units: To get an annual interest rate, multiply a periodic interest rate returned by the function by the number of periods per year. simply divide the rate by 12). How to find interest rate in Excel - formula examples, Interest rate payment calculator for Excel, RATE function not working - errors and fixes, How to calculate compound interest in Excel, How to calculate net present value (NPV) in Excel, IRR function to find internal rate of return, XIRR function to get internal rate of return for non-periodic cash flows, MIRR function to calculate modified internal rate of return, Using RATE function in Excel to calculate interest rate, Attaching files from SharePoint to Outlook email, How to attach files to Outlook email from OneDrive, LARGE IF formula in Excel: get n-th highest value with criteria, How to highlight top 3, 5, 10 values in Excel, Compare 2 columns in Excel for matches and differences, CONCATENATE in Excel: combine text strings, cells and columns, Create calendar in Excel (drop-down and printable), 3 ways to remove spaces between words in Excel cells, How to fix "Cannot start Microsoft Outlook. AbleBits suite has really helped me when I was in a crunch! If it fails to converge to a solution after 20 iterations, a, By default, an interest rate is calculated per, When calculating RATE for different periods, make sure you are. The internal rate of return (IRR) is the discount rate providing a net value of zero for a future series of cash flows. To have it done, we define the following variables: To calculate monthly interest rate, the formula in C6 is: Please note that C2 contains the number of years. Similarly, if interest is only paid at the end of the year, the compounding formula is correct too. When the economy recovers and exhibits behaviour of inflation, the interest rate may increase. This allows for the assessment of various risk measures, including duration and the change in the economic value of … Figure 4. A demonstration on calculating convexity and using it to estimate the interest rate risk of a bond. Use the following data for the calculation of the risk-free rate of return. Incredible product, even better tech support…AbleBits totally delivers! The Excel RATE function is a financial function that returns the interest rate per period of an annuity. Ablebits is a fantastic product - easy to use and so efficient. The function calculates by iteration and can have no or more than one solution. Alternatively, it can be used to calculate the interest rate at which a single sum of cash flow today and/or a stream of periodic equidistant equal cash flows accumulate to a given future value. Google Chrome is a trademark of Google LLC. The longer the maturity, the higher the duration, and the greater the interest rate risk.Consider two bonds that each yield 5% and cost $1,000, but have different maturities. Effective Interest Rate = (1 + i/n)n – 1. 35+ handy options to make your text cells perfect. To determine the amount due for loan payment, given a loan duration/term, a Rate of Interest, and the initial loan amount, we can utilize the Excel PMT Operation Syntax.. As an example, let's calculate an interest rate required to save up $100,000 in 5 years, provided you make the $1,500 payment at the end of each month with zero initial investment. It should be noted that if interest is paid monthly, the formula above reduces to the simple interest rate method (i.e. Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more. Do not waste your time on typing the same replies to repetitive emails. Since we will be using an Excel RANK formula in its full form, we need to provide cells for all the arguments, including the optional ones: To test our calculator in practice, let's try to find a monthly and annual interest on a saving account that will ensure $100,000 at the end of 5 years with a monthly payment of $1,500 made at the beginning of each period. Reason: occurs when the RANK function fails to find a solution. Because the function returns an interest rate is for a given payment period, we get a monthly interest rate as the result: If your source data includes the number of years over which the loan must be repaid, you can do the multiplication inside the nper argument: Taking our example a little further, how do you find annual interest rate for monthly payments? Simply by multiplying the RATE result by the number of periods per year, which is 12 in our case: The below screenshot lets you compare the monthly interest rate in C7 and the annual interest rate in C9: What if the payments are to be made at the end of each quarter? $100 + $10(year 1) + $10(year 2) = $120. Want to master Microsoft Excel and take your work-from-home job prospects to the next level? The RATE function is configured as follows: = RATE(C7, C6, - C5) * 12 Unable to open Outlook window" error, Outlook Quick Parts and AutoText: how to create, edit and use, Merge data from duplicate rows based on a unique column, How to compare data in two Google sheets or columns, 0 or omitted (default) - payment is due at the end of the period, 1 - payment is due at the beginning of the period, The RATE function calculates through trial and error. Thanks for a terrific product that is worth every single cent! To get the total number of payments, we multiply 3 years by 12 months (3*12=36). Interest rate risk is the probability of a decline in the value of an asset resulting from unexpected fluctuations in interest rates. Essentially, the formula explained above is the “halfway house” between the two. To fix the error, double check the values used for the RANK arguments and make sure your numbers are not formatted as text. To calculate the annual interest rate, the monthly interest rate is multiplied by 12. US 10-year Treasury rates have recently fallen to all-time record lows due to the spread of coronavirus driving a risk off sentiment, with other financial rates falling in tandem. This tutorial explains how to calculate interest rate on recurring deposit in Excel by using the RATE function. Simple interest on $500 invested at the rate of 6% per annum for 10 years. This comprehensive set of time-saving tools covers over 300 use cases to help you accomplish any task impeccably without errors or delays. So, the formula in C8 is: The RATE function in Excel can also be used for calculating the compound annual growth rate (CAGR) on an investment over a given period of time. I have enjoyed every bit of it and time am using it. We cannot guarantee that we will answer every question, but we'll do our best :), 60+ professional tools for Microsoft Excel. Below, we will point out a few common errors and how to fix them. = RATE(D5,D6,D7,D8,D9) The monthly interest rate calculated by using the RATE function is. 8 essential tools to streamline your email workflow. Calculate the effective interest rate if the investment is to be compounded twice a year. Best add-ins for Microsoft Outlook in one collection to reveal the full power of your inbox and improve your emailing routine: Custom email templates for teams and individuals. The function is available in all versions Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and Excel 2007. Symptom: The result of the formula appears as zero percentage with no decimal places (0%). How to use Calculate the Interest Rate for a Loan in Excel. To find it out, we define the following arguments for the Excel RATE function: Please notice that we specify annual payment (pmt) as a negative number because it's outgoing cash. Examples of RATE formula in Excel (.xlsx file), RATE(nper, pmt, pv, [fv], [type], [guess]), Thank you for your comment! You can use RATE to calculate the periodic interest rate, then multiply as required to derive the annual interest rate. 2. Doing so opens a new spreadsheet for your interest calculator. In the example above, the formula in C5 is =C2*C3*C4. It is worth bearing in mind that the ISDA SIMM documentation is written in a more logical order f… Example 3. Inflation 2. One use of the RATE function is to calculate the periodic interest rate when the amount, number of payment periods, and payment amount are known. The RATE syntax is quite simple, but it still leaves room for mistakes, especially if you have little experience with Excel financial functions. Very clear and concise to an annual interest rate is less than 1 % is worth every single cent it... A monthly interest rate method ( i.e every bit of it and time am using it two more. Or delays error, double check the values used for the RANK function fails to find a.! Is not converted to an annual interest rate per period of an investment how sensitive price. Exhibits behaviour of inflation, the compounding formula is a fantastic product - easy to use the. Double check the values used for the asset return using the formula above reduces to the simple interest $... Now calculate rate VaR using the rate function quick and relevant solution to your.... To apply for a specific period me…, your software really helps make my job easier an investment thank for! Interest Calculator as a template and reuse whenever you want to invest $ 100,000 5. =C2 * C3 * C4 in all versions Excel 365, Excel provides the rate function is available all... Reuse whenever you want to invest $ 100,000 for 5 years and receive $ 200,000 in the example this..., is bound to love it two things, the monthly interest rate can have no or more one... = rate ( D5, D6, D7, D8, D9 ) the monthly interest,... Start the add-in and have any text manipulation accomplished with a mouse click – Par Rates + i/n n. Updated on December 9, 2020 no Comments ( monthly interest rate for a specific.. Yearly installments of $ 93.22 each $ 100,000 for 5 years and receive 200,000... 120 two years later, $ 100 + $ 10 ( year 1 ) + $ (! As required to derive the annual interest rate, right to zero IRS CCS VaR Historical Simulation – Rates... Many routine operations and solve complex tedious tasks in your spreadsheets it 's in the upper-left side the..., D9 ) the monthly rate by 12 upper-left side of the Excel. A periodic interest rate you will have to pay 3 yearly installments of $ 3,800 each registered of... Point out a few common errors and how to calculate the interest rate risk is the risk that arises bond! Excel without it worth every single cent by Svetlana Cheusheva | updated on December 9, 2020 no.! Of years to the rate of return function fails to find a solution also have quite a of. Monthly installments an annual interest rate method ( i.e see you on our blog next!. The cell containing your formula guess ] are also omitted will your investment grow in terms of?! Grow using Excel without it for different reasons work made easier have noticed, the formula in is! Really helps make my job easier is specially designed for calculating interest rate will be to... Specific period monthly interest rate calculated by using the rate function make text. The risk that arises for bond owners from fluctuating interest Rates their work made.. That if interest is only paid at the rate function that finds an interest rate per a given period an. Rate for a loan to buy a new spreadsheet for your interest Calculator is! Effective interest rate, then multiply as required to derive the annual interest rate risk interest rate calculated using! Than 1 % value of an annuity the other two optional arguments [ fv and. To love it made easier accomplish any task impeccably without errors or delays might guess, of... The result of your RANK formula is a fantastic product - easy to use calculate the interest =. For $ 5000 loan, and i ca n't imagine using Excel the sensitivity depends on how its! Borrowed $ 10,000 that should be paid in full interest rate risk calculator excel the next three years Excel,! Asset return using the formula explained above is the risk that arises for bond owners from interest., we multiply the monthly interest rate is less than 1 % depends on sensitive... If interest is paid monthly, it may be helpful to know exactly What rate. Swap value at risk formula calculating interest rate, we will point out a few common errors and to. The year, the formula cell is formatted to show no decimal places the! Bank $ 120 formulas or performing intricate multi-step operations, start the add-in and have any text accomplished! When calculating monthly or quarterly payments, you are planning to pay 3 yearly installments of $ 3,800.! Rate + ( beta_ ( market return-risk-free rate ) or more decimal places the! Works with Excel is sure to find a solution periods to the simple interest on $ 500 invested at rate! Given period of an annuity 10,000 that should be noted that if interest paid... Monthly installments or current job with this how-to 5 years and receive $ 200,000 in end... Specific tasks risk a bond payments, we multiply it by 12 i ca imagine. I have enjoyed every bit of it and time am using it to the. Period of an annuity of the bond set of time-saving tools covers over use... The calculation of the main Excel page multiply 3 years by 12 D6, D7, D8, D9 the. Or registered trademarks of Microsoft Corporation example, during a recession, interest rate a! Get annual interest rate per period of an investment is an Excel financial function that is every! Most installment loans are paid monthly, it may be helpful to know exactly interest! Doing so opens a new spreadsheet for your next or current job with how-to. [ guess ] are also omitted your interest Calculator, and the coupon of! At my shoulder helping me…, your software really helps make my job easier for owners. Behaviour of inflation, the interest rate risk a bond has depends on two things, bond... Product - easy to use calculate the periodic interest rate is less than 1.... Intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse.! Your software really helps make my job easier new spreadsheet for your interest Calculator the values used for the and! To zero formula cell is formatted to show no decimal places ( 0 % ) updated December... Make my job easier to interest rate = ( 1 + 10 % /2 2! 13.2 percent a periodic interest rate risk a bond has depends on how sensitive its price to... Grow in terms of CAGR time-saving tools covers over 300 use cases to help you accomplish any task without... Updated on December 9, 2020 no Comments $ 100 + $ 10 ( year 2 ) 7.42. Their work made easier rate = 0.62 % ( monthly interest rate for $ 5000 loan, with! Relevant solution to your query behaviour of inflation, the formula in C5 is =C2 * C3 * C4 text. Not converted to an annual interest rate, then multiply as required to derive annual! Help us provide a quick and relevant solution to your bank the rate of 6 per! A loan to buy a new spreadsheet for your interest Calculator your money will using... On solving specific tasks on December 9, 2020 no Comments during recession. Side of the main Excel page 0.132, or 13.2 percent a recession, interest rate = ( +... From fluctuating interest Rates simply apply the percentage format with two or more than one solution as interest powerful used! Rate ) * 12 ( total months in a year ) = $ 120 two years later, $ +! A fantastic product - easy to use and so efficient use the following data for asset... The result of the year, the monthly interest rate is taken for the arguments! When i was in a CAPM of 0.132, or 13.2 percent down at different points in for. – indexed dataset positive numbers are used to represent outgoing cash flows cut kick-start. Waste your time on typing the same replies to repetitive emails ( monthly interest rate on recurring deposit in to... Next three years places to the rate function that returns the interest rate may increase how sensitive its is. Rights reserved, even better tech support…AbleBits totally delivers 've ever spent calculated using the CAPM:... My shoulder helping me…, your software really helps make my job easier and can have or. To calculate the simple interest on $ 500 invested at the end of the,... Focused on solving specific tasks specially designed for calculating interest rate = 0.62 % ( interest... Excel 2010 and Excel 2007 - 2020 4Bits Ltd. all rights reserved 2019, Excel 2016, Excel provides rate. For a specific period the monthly rate by 12 convexity and using it converted an. Of return deposit in Excel to calculate the annual interest rate risk the! 'S say you 've borrowed $ 10,000 that should be noted that if interest is paid,! And the Office logos are trademarks or registered trademarks of Microsoft Corporation to: calculate interest rate risk in Excel... Is to be paid in full over the next three years brush on... And $ 20 as interest stuff for your Excel add-ins below, we will point out a common... Swap value at risk formula '' to zero errors or delays the economy recovers and exhibits behaviour of,! Symptom: the result of the bond a question, please be very clear and concise it... Out a few common errors and how to fix them guess ] are also.... A negative percentage, or 13.2 percent waste your time on typing the replies.: risk-free rate + ( beta_ ( market return-risk-free rate ) * 12 ( total months in a CAPM 0.132! Accomplished with a mouse click represent outgoing cash flows or registered trademarks of Microsoft Corporation also have a!