do assignments using excel and manually if possibly A student plans to open a business with the courage to borrow $1740,11 and will return the same amount every year for 5 years. If the loan interest from (Small Business Credit) is 6%/year. How much is the student's installment/year?
Q: Use the future value formula to find the indicated value FV=5,000; i = 0.03; PMT = $400; n=? n= (Rou...
A: Data given: FV= $ 5000 i= 0.03 PMT = $ 400 Required:: n Formula to be used :: FV= PMT*(1+i)n-1i ...
Q: An investor purchases a plot of land for £400,000 and intends to construct a building which will be ...
A: First, we will find the Rental income after considering a 5% increment every year then we will calcu...
Q: 14. Find the accumulated value at the end of 10 years if P100 is invested at the rate of 12% compoun...
A: The accumulated value is calculated as the future value of account
Q: 4. (Present value of an ordinary annuity) What is the present value of the following annuities? c. $...
A: c) Annual payment (A) = $280 n = 7 years r = 6%
Q: Your parent started to deposit monthly $20,000 in the bank 2 years after birth. The bank offers are ...
A: Amount deposited $20,000 monthly Rate of interest is 6%.
Q: (Refer to this word problem The accumulated value of a 3-month loan of P5,000 is P5,085.' Accumulate...
A: The Calculation of the interest and principal as follows: Loan amount = PHP 5000 Interest Rate = 6.8...
Q: In certain cases, experience will indicate the best time to perform certain operations to maintain e...
A: Answer - Part 1 - Calculation of Cost per piece - ( 200 pieces) Particular Amount Piece pro...
Q: (Related to Checkpoint 5.2) (Future value) Leslie Mosallam, who recently sold her Porsche, placed $1...
A: Compounding is a technique to compute the future value (FV) of present cashflows by considering a ra...
Q: A $50,000 loan is to be repaid in equal yearly payments over 20 years at an interest rate of 3% comp...
A: The amount to be paid each year means what amount should be paid over the life of loan such that ful...
Q: Two bonds are selling at par value and each has 17 years to maturity. The first bond has a coupon ra...
A: Duration refers to the price sensitivity of a bond, or a portfolio of bonds, to a change in interest...
Q: 1. Which of the following models for mathematics of the financial markets is dependent on expectatio...
A: "Since you have asked multiple question we would be solving first question ,If you want any specific...
Q: You are analyzing the leverage of two firms and you note the following (all values in millions of do...
A: Market Debt to Equity Ratio = Debt /Market value of Equity Book Debt to Equity Ratio = Debt /Book va...
Q: Suppose you want to buy a $150,000 home. You found a bank that offers a 30-year loan at 4.1% APR. Wh...
A: Cost of House is $150,000 Time period is 30 years and 25 years. APR is 4.1% To Find: Monthly paymen...
Q: Maybepay Life Insurance Co. is selling a perpetual annuity contract that pays $3,500 monthly. The co...
A: Value of Annunity or current selling price is $338,000 Monthly payment is $3,500 To Find: Interest ...
Q: You win the lottery and are offered the following choices. The appropriate discount rate is 7%. How ...
A: We need to compute the present value of all payments and compare the PV of all options.
Q: (Refer to this word problem. Samuel wishes to have P500,000 available for his son's college educatio...
A: Here we have to find the present value so that P 500,000 is available after 14 years.
Q: Assume the zero-coupon yields on default-free securities are as summarized in the following table: 2...
A: Bonds are the debt securities which are issued by the corporations or the government to raise the fu...
Q: 1. Simple Interest versus Compound Interest First City Bank pays 7 percent simple interest on its sa...
A: First city bank simple interest rate (i) = 7% Second city bank compound interest (r) = 7% Deposit (D...
Q: A company hires an employee with a family of 3 for a salary of $160,000 over 3 other candidates. If ...
A: Recruiting costs are the costs that are incurred by the company in hiring and training new employees...
Q: A city is spending $20 million on a new bridge. Operating and maintenance expenses for the bridge ar...
A: First cost (C) = $20 million Annual cost (A) = $0.6 million from year 3 Major repairs cost (R) = $1....
Q: Wells, Inc., has identified an investment project with the following cash flows. Year Cash Flow $ 1,...
A: Future value at year 4 = [Year 1 cash flow x (1 + r)3] + [Year 2 cash flow x (1 + r)2] + [Year 3 cas...
Q: Identify and discuss the relations among a bond’s coupon rate, the yield required by the market, and...
A: Bond prices are the price that we see trading in the market. these prices can be calculated by takin...
Q: A certain type of machine loses 10% of its value each year. The machine cost P2,000 originally. Make...
A: Machine cost = P2,000 Depreciation rate = 10%
Q: A BBB-rated corporate bond has a yield to maturity of 13.6%. A U.S. Treasury security has a yield to...
A: a. Let's assume the face value of the Treasury bond is $1. Determine the price of Treasury bond (as ...
Q: What is the future value of the following cash flows AT THE END OF YEAR 5, assuming a 6% interest ra...
A: Interest rate is 6% Compounded annually To Find: Future value at the end of 5 years
Q: what are the legal aspects concerning bill discounting?discuss the decision analysis for factoring s...
A: Bill Discounting is a business-related activity in which unpaid bills from a firm that are expected ...
Q: 10. We have the following exchange rates. $1.58/E1, $1.30/€1, and €1.40/E1. What will be the profit ...
A: From third relation, 1 Pound = 1.40 Euro
Q: n model holds, wl that the mark ure
A: Given information : EPS ₹ 5.00 ROE 16% Market price ₹ 50.00 DPR 40% Since ...
Q: 3. (Future value of an ordinary annuity) What is the future value of each of the following streams o...
A: a. Calculate the future value of ordinary annuity by using the EXCEL FV function: Working: Thus, t...
Q: 3 years. Calculate the capitalized cost if an annual maintenance of P 590,000 is required. Express ...
A: Given information : Rate of interest 7.50% Bridge cost 200 Time period 23 Partial cost 14...
Q: Find the EAR in each of the following cases. (Do not round intermediate calculations and enter your ...
A: An effective annual rate of interest or E.A.R. is the interest which is earned in real times over a ...
Q: At what annual interest rate must $232,000 be invested so that it will grow to be $452,000 in 14 yea...
A: Present value (PV) = $232000 Future value (FV) = $452000 Period (n) = 14 Years
Q: American General offers 11-year annuity with a guaranteed rate of 6.42% compounded annually. How muc...
A:
Q: ABC’s semiannual bond has a clean price of $1013. It paid its last coupon of $50 65 days ago. Calc...
A: Current yield is the ratio of annual dividend to the current price per bond.
Q: Calculate the net profit margin for a mixer sold for $125 that has an $80 cost of goods sold and 20%...
A:
Q: Both of Firm A and Firm B are 100 equity firms. You estimate that the incremental value of the acqui...
A: Merger is the concept of two or more company combined together and form a new company or one company...
Q: Consider an economy with three states which occur with probability (0.2, 0.2, 0.6). Suppose a firm ...
A: CAPM means Capital Assets Pricing Model. The formula for CAPM is: E(r)=Rf+beta(Rm-Rf) NPV is the dif...
Q: To provide for university education fees, money needs to be saved today. What single amount is neede...
A: Present Value: The present value is the value of cash flow stream or the fixed lump sum amount at t...
Q: An air purifier for use in manufacturing semiconductors is placed in service with a first cost of $5...
A: Given: Life = 8 Years Income less expenses = $14,000 Tax rate = 25%
Q: Mr. Abella owes Mr. Divinagracia the following obligations. (1) P100 due at the end of 10 years.(2) ...
A: First obligation (X1) = P 100 in 10 years Second obligation (X2) = P 200 in 5 years + Interest at 5%...
Q: Copy of Find the amount at the end of 3 years and 10 months if P3,000 is invested at 89% compounded ...
A: The worth of a present asset at some point in the future based on a projected growth rate is referre...
Q: 28. Annie buys a television set from a merchant who asks for P1,250 if paid at the end of 60 days. H...
A:
Q: Which of the type of insurance pays benefits to workers who suffer an injury on the job? Select the ...
A: Insurance is an agreement in which an individual or organization obtains financial security or compe...
Q: Use Gordon formula to calculate the price of the stock. ITC company expected to pay dividend of $4 a...
A: Expected dividend (D1) = $4 Growth rate (g) = 3% Required return (r) = 8%
Q: Harding Company is in the process of purchasing several large pieces of equipment from Danning Machi...
A: Data given: Payment options: 1.Pay $1,130,000 in cash immediately.2. Pay $402,000 immediately and th...
Q: 6. Find the nominal rate compounded monthly which is equivalent to 12% compounded quarterly.
A: Compound Interest Compound Interest refers to the interest generated on principal as well as on the ...
Q: The average rate of return on a 182-day Government of Canada treasury bill sold on June 18, 2021, wa...
A: Par Value of bond is $100,000 Time period to maturity is 182 days Rate is 1.03% at the time of issue...
Q: Juju Corporation buy Bilu bonds for 20 years and has been issued 12 years ago at a coupon rate of 7%...
A: Hi, note the data for part b is incomplete. No infomration on the maturity term of Cucu bond is prov...
Q: Lux Co. recently reported sales of P100 million, and net income equal to P5 million. The company ha...
A: Answer - Additional funds needed (AFN )is a financial concept used when a business looks to expand ...
Q: PharmPic is considering the following project with the following cash flows: ...
A: Cash flows for Pharmpic project: Cash flows for DosageDoc project To Find: Payback period Discoun...
Step by step
Solved in 2 steps
- In order to start a small business, a student takes out a simple interest loan for $3000 for 9 months at a rate of 11.25%. a. How much interest must the student pay? b. Find the future value of the loan.In order to start a small business, a student takes out a simple interest loan for $2000.00 for 6 months at a rate of 7.00%. a. How much interest must the student pay? b. Find the future value of the loan. a. The amount of interest is (Round to the nearest cent as needed.) b. The future value is (Round to the nearest cent as needed.)I’m order to start a small business, a student takes out a simple interest loan for 8000 for 3 months at a rate of 9.00%. How much interest must the student pay? Find the future value of the loan
- You are planning on enrolling in the Master of Finance in 4 years time and will be required to pay $45,000 in fees upfront at enrolment. If you can earn 5.4% p.a. on your money, how much would you need to deposit into a savings account today in order for you to have enough money to pay your fees? [Round to the nearest dollar] Select one: a. $45,282 b. $34,595 c. $36,463 d. $41,514You are interested in saving for a trip when you graduate in three years. You can save $75 each of the next 36 months and earn 2.75% interest on your money. How much money would you have in your savings account in 36 months for your trip? ( Please reference the loan infromation in the "Task 5 Data " cells as the argument for your functionsA person deposits $500 into an account that earns 4.75% annually. If no oth are made, how much interest will the account have earned after 12 years? CCESS Virtual Learning 2022
- You borrowed $10,000 from a bank to invest in IT & Mobile technology with payback the loan in graduated payment plan. If your first payment is $1,000 at the end of first year and i=10% over 5 years. Note: (P/G, 10%, 5) = 6.86 Q/Find the total earned interest by the bank at the end of period?Solve the following problem. Use Excel, financial calculator, or PV and FV Tables. Show your work with the formulas and figures inserted in them. Hamad is saving to establish a small business. He deposits a fixed amount of money every month in a bank account that pays a nominal interest rate of 12 percent. If this account pays interest every month, then how much he should save at the end of every month to have AED 50,000 in his account after 5 years.2. A student has an internship in their senior year whereby they were able to save some money (call this variable SAVE). They deposit this money into the bank with an interest rate of 5% per year. How long will it take for them to have their bank account double if the interest is compounded: a) Annually, b) Quarterly, c) Monthly, d) Daily Group 1: your SAVE amount is $5000 amount is $5500 Group 2: your SAVE Group 3: your SAVE Group 4: your SAVE Group 5: your SAVE amount is $7000 Group 6: your SAVE amount is $7500 amount is $6000 amount is $6500
- THE PICTURE IS THE EXCEL TEMPLATE YOU MUST FILL OUT Suppose that you borrowed $25,000 student loans from Sallie Mae to attend UM - Dearborn. Once you graduate, you are required to start paying your loan and interest. The APR for your loan is 5.54%. Each month you will have to make interest payment and principal repayment. Suppose that you can choose the following two repayment plans: Standard repayment plan: if you choose this plan, you will have to pay off your loan in 10 years with the same amount of payment each month. Fixed extended repayment plan: if you choose this plan, you will be allowed to pay off your loan in 25 years with the same amount of payment each month. 1. Please use Excel to work on the following questions: How much should you pay each month for these two plans? • Set up the loan amortization tables for these two plans. How much interest will you pay in total when you pay off your loan for these two plans? • Amortization Schedule for your Student Loan (Standard…How much would you need to deposit in an account each month in order to have $20,000 in the account in 9 years? Assume the account earns 6% interest. Submit Question .com/course/showcalendar.php?cid=179278 Q Search2. Remi deposits $2,000 into a savings account at her bank. If the interest rate is 3.25 percent, how much money will she have in her account after 5 years? 7. You are Co introductory rate months and the rate be entered into a drawin commercial. You pay $50 a you switch? Use the smart dec mathematically and include an em