**I need to know how to do it by had without a financial calculator or excel....

**I need to know how to do it by had without a financial calculator or excel. Unsure of what formula to use.**

If a 4-year bond with a 7% coupon and a 10% yield to maturity is currently worth $904.90, how much will it be worth 1 year from now if interest rates are constant?

A)$947.93

B) $925.39

C) $904.90

D)$1,000.00

Expert Solution

jeff jeffy answered 2 years ago

I need to know how to do this IN EXCEL, please! Dennis wants to determine if...

I need to know how to do this IN EXCEL, please! Dennis wants to determine if the discount rate really makes any difference in the net present value of a project. He feels that if a project is acceptable at one rate of return, it will be acceptable at all rates of return. To explain why his thinking is incorrect, you are creating an example to illustrate your point. The cash flows you are using are as follows: time zero...

Essentials of Investments- Bodie, Kane and Marcus. PLEASE WITHOUT EXCEL and WITHOUT FINANCIAL CALCULATOR! And PLEASE...

Essentials of Investments- Bodie, Kane and Marcus. PLEASE WITHOUT EXCEL and WITHOUT FINANCIAL CALCULATOR! And PLEASE do not abbreviate the process! If you need to calculate the cash flows or the present value, please clarify and step by step without abbreviating the process. I mean do not write like this: "32.5 x PVIFA @ 3%, 10 years" or like this: "= 32.5 / 1.06 ^ 0.5 .... 1032.5 / 1.06 ^ 20 = 1057.79" . I NEED TO SEE THE...

How do I do these computations without a normal distribution chart and just a TI84 calculator?...

How do I do these computations without a normal distribution chart and just a TI84 calculator? 6.7 Given a standard normal distribution, ﬁnd the value of k such that (a) P(Z>k)=0 .2946; (b) P(Z<k)=0 .0427; (c) P(−0.93 <Z<k)=0 .7235. 6.8 Given a normal distribution with μ = 30 and σ = 6, ﬁnd (a) the normal curve area to the right of x = 17; (b) the normal curve area to the left of x = 22; (c) the normal...

I need to know how to figure this problem by doing in excel. Hypertensive Status by...

I need to know how to figure this problem by doing in excel. Hypertensive Status by Clinical Trial Site--Observed: Site Hypertensive 1 2 3 Yes 17 23 35 No 83 77 65 Question: Data from 300 patients recruited for a clinical trial. The trial recruited patients from three different sites. Use this data to determine if there is a difference in the number of hypertensive patients across clinical sites. Interpret your results. Is the p-value calculated significant?

How do I solve this system of equations without using a calculator or fancy matrix math?...

How do I solve this system of equations without using a calculator or fancy matrix math? v1 = 1.8 v2 = ? v3 = ? (1) v1 = 1.8 (2) 7150v2+1350v3 = 12780 (3) 7150v22 + 1350v32 = 23166

I need to create a monthly loan Calculator in C++. I know the formula but can't...

I need to create a monthly loan Calculator in C++. I know the formula but can't figure out what's wrong with my code. Any clarification would be appreciated! // Only add code where indicated by the comments. // Do not modify any other code. #include <iostream> #include <cmath> using namespace std; int main() { // ---------------- Add code here -------------------- // -- Declare necessary variables here -- int years = 0; //n int LoanAmount =...

I need to write a resume and I do not know how to write it. Please...

I need to write a resume and I do not know how to write it. Please help me. My name is John Doe. I finished Associate of Science in (Electrical Engineering, Computer Engineering, Physics and Math) from Community College. I have work experience over 10 years at food company. Please help me write as completely as possible. Thanks a lot for your help!

I need Calculator project : A complex number calculator program that allows the user to do...

I need Calculator project : A complex number calculator program that allows the user to do either addition, subtraction, multiplication or division where a complex number is a number of the form a + bi where a and b are real numbers and i equals √ −1. 1. It must consist of at least five functions excluding the main function. 2. There should be a function for each operation. Each of these functions should handle checking the validity of its...

Before this class, what had you used Excel for? Do you know how to do something...

Before this class, what had you used Excel for? Do you know how to do something now that could have improved your previous creations?

Does anyone know how to do it on EXCEL? Does anyone know how to do it...

Does anyone know how to do it on EXCEL? Does anyone know how to do it on EXCEL? Does anyone know how to do it on EXCEL? Does anyone know how to do it on EXCEL? Anyone know how to do it on EXCEL? The Statistical Abstract of the United States published by the U.S. Census Bureau reports that the average annual consumption of fresh fruit per person is 99.9 pounds. The standard deviation of fresh fruit consumption is about...

Question