Q: Consider two lotteries. Lottery A is such that an individual receives a prize of 1.25 units of a con...
A: The expected value is determined by multiplying the probability with its units. This is expected val...
Q: How much would a business have to invest in a high-growth fund to receive $13,000 every month for 7 ...
A: First we need to calculate present value of all withdrawals by using the following formula PV...
Q: Current market price of ABC stock is $77 ABC Stock price after 30 days =$80 ABC Stock price after 45...
A: A) Price or face value of call option as on today = MAXIMUM,{0, CURRENT MARKET PRICE(CPM)-EXCISE ...
Q: Sixty monthly deposits are made into an account paying 8% nominal interest compounded monthly. If th...
A: We need to use future value of ordinary annuity formula to calculate monthly payment PMT =FVn(1+r)n ...
Q: A contract has been signed to lease a building at P21.483 per year with an annual increase of P1,045...
A: Given: Lease = P21,483 Annual increase = P1,045 Years = 10 Interest rate (Rate)= 8.78%
Q: You are a loan officer of Third National Bank and already way behind your target revenue for the yea...
A: Banks gives loan to the business so that they can grow the business and bank also get the business a...
Q: Devin started a fund that would pay out $1,400.00 every month in perpetuity. The fund earns 3.72% co...
A: Perpetuity Perpetuity is the series of fixed payments which is incurred or received for the infinite...
Q: ract requires lease payments of $900 at the beginning of every month for 3 years. a. What is the pre...
A: The present value of annuity is the value of annuity without interest and that is the value today.
Q: Find the present value of the following ordinary deferred annuity. Periodic Made Payment Period Peri...
A: First, we will compute the annual effective rate based on quoted rate and quarterly compounding. The...
Q: What is the micro-stop store's gross profit, if the total sales is P125,750.00 and the cost of sales...
A: Total sales = P125,750.00 Cost of sales ratio = 42.25%
Q: Suppose that standard deviation of monthly changes in spot prices of live cattle is 1.2 cents per po...
A:
Q: How much should Ryan have in a savings account that is earning 2.50% compounded monthly, if he plans...
A: Present Value of Annuity: It represents the present worth of the future cash flows stream and is co...
Q: Tom has decided to invest $400 quarterly for 4 years in an ordinary annuity a 8%. As his financial a...
A: Quaterly investment amount is $400 Time period is 4 years Interest rate is 8% To Find: Cash value o...
Q: Lou Lewis, the president of Lewisville Company, has asked you to give him an analysis of the best us...
A: Evaluating alternatives: When a company is faced with the choice of two alternatives, both alternati...
Q: Identify whether each of the following is an example of adverse selection or moral hazard. A. Joe be...
A: A phenomena where there is asymmetric information between the parties involved in a transaction are...
Q: Redan, Inc., is expected to maintain a constant 5.4 percent growth rate in its dividends, indefinite...
A:
Q: At an interest rate of 10% per year, the perpetual equivalent annual cost of $70,000 now, $100,000 a...
A: Perpetual equivalent annual cost in simple words is an annual cost of one period considering the who...
Q: Nike Enterprises sells widgets for $10 a piece which cost them $6 to make. In a good year (probabili...
A: Since question involves multiple subparts , we will answer 1st sub 3 parts for you as per prescribed...
Q: Steph creates a ratio spread by buying four 100-strike put options and selling one 110-strike put op...
A: A put option (or "put") is a contract that grants the option buyer the right, but not the obligation...
Q: Firm Z has issued 1,000,000 bonds. Each bond is priced at $929 and has a face value of $1000. It pay...
A: Price of bond = 929 Face Value = 1000 Annual Coupon = Coupon Rate * Face Value = 3%*1000 = 30 N = 20...
Q: What is the impact of deferred annuities in consideration to business matter?
A: The legal contract between any entity and an insurance company is a deferred annuity contract. The i...
Q: The SUTA rate for Thomson Temp Agency is 5.4% and it’s FUTA rate is 6% less the 5.4% SUTA credit. If...
A: The following is the Calculation of total FUTA and SUTA taxes: SUTA tax = $378FUTA t...
Q: What is the compound amount and interest if Php 10,000 is invested at 3.6% compounded monthly for 2 ...
A: we know that, A=P(1+rn)n×t now, A= amount after time + (future value) P= principal amount (initial v...
Q: A Forward Rate Agreement contains an agreed interest rate of 5.75% on a 6-month loan. If settled at ...
A: Forward rate agreements are used by entities to hedge against interest rate risk. It is an over the ...
Q: Situation: Your friend came to you for advice whether or not to invest in a particular stock which p...
A: Given: Profit = $200,000 Probability of profit = 30% Loss = -50,000 Probability of loss = 70%
Q: What is the total interest paid to the nearest cent if the car costs $36,915, your down payment is $...
A: A credit score is a metric which shows the ability of a person or an organisation to repay its debt ...
Q: Firm Z has issued 1,000,000 bonds. Each bond is priced at $929 and has a face value of $1000. It pay...
A: Firm Z has different sources of capital - debt, equity and preferred stock. We will have to find the...
Q: Differentiate between the Passing of Risk and the Passing of Ownership.
A: when the goods are sold the risk remains with the seller until the property in the goods is transfer...
Q: Assume the $12,480 Treasury bill, 5% for 15 weeks. Calculate the effective rate of interest. (Use ca...
A: Effective rate of interest = Amount of interest / [ (Principal - Amount of interest) x Time period ...
Q: Pearson's books had total markdowns of $1,125 and a net markdown of $434 for the month of October. C...
A: Mark down is the reduction in price of an item below its original selling price. Markup cancellation...
Q: 4) Suppose you are a financial manager for the Shah Corporation and trying to decide between the fol...
A:
Q: 3. Pielago is eyeing for another company to invest her excess funds. She is interested in a publicly...
A: Constant Growth Model: Under this model, it is assumed that dividends paid by the company go up at ...
Q: F G H Monthly Monthly Еxcess Excess return for Market Stock 1 Returns 0.09 0.03 -0.07 0.01 0.02 0.02...
A: Risk and return are two main components of investment. Beta a measure which shows the degree of risk...
Q: In four years of employment, John was able to save P250,000 after he had invested on purchasing a mo...
A: The stock market is a location where traders may purchase and sell equities,investors can invest in ...
Q: Are the following capital budgeting or financing decisions?
A: Capital budget involves evaluation and comparison of costs and benefits from a project. Capital budg...
Q: INFO ON STOCK Years 4 Beta 2.89 Divadends QUESTIONS D1 4.89 D2 4.76 REQUIRED RETURN ON EQUITY Foreca...
A: Given: Info on stock Year 4 beta 2.89 Dividends D1 4.89 D2 4.76 D3 3.98 D4 3.25...
Q: An asset is expected to pay a cash flow of $10 every 6 months in perpetuity with the first cash flow...
A: Future value (FV) is the worth of a present asset at a future date based on an estimated rate of gro...
Q: Condominiums usually require a monthly fee for various services. At $280 a month, how much would a h...
A: Monthly fee = $280 Period = 12 years = 12*12 = 144 months
Q: lolanda purchased a Treasury bond with a coupon rate of 2.62% and face value of $100. The maturity d...
A: Here, Purchase Date is 7/Feb/2018 Maturity Date is 15th/ April/2019 Time Period between two dates is...
Q: A fianncial security generates a cash flow of 2 million every five years forever with the first cash...
A: Perpetuity is an annuity with indefinite life. Security's price today will be the present value of p...
Q: As a Project Engineering had been tasked to make an analysis and to recommend to your company on the...
A: Concept ROI means return of income. It is one of performance measure used to evaluate efficiency on ...
Q: Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets a...
A: We need to use the following formulas for ratio Total debt ratio =Total liabilities/total assets Deb...
Q: Find the present value of the following ordinary deferred annuity. Periodic Made Payment Period Peri...
A: A deferred annuity: A series of finite, constant receipts/payments made at fixed intervals is known...
Q: (Using common-size financial statements) The S&H Construction Company expects to have total sales ne...
A: Pro-Forma Income Statement Sales $1,54,00,000 Cost of Goods Sold ($15400000 * 62%) $95,48,000 ...
Q: The following are the information on the assets and labilities of DARARI Corporation on December 31,...
A: Acid test ratio Acid test ratio is a measure of the liquidity position of a firm. It indicates the f...
Q: Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets a...
A: Solution:- Debt equity means the ratio of debt to the equity in the capital structure of the company...
Q: how much will this collection be worth when that time comes?
A: Future Value: It represents the future worth of the present sum of money and is computed by the pro...
Q: Chelsea FC has $15 million debt outstanding due next year and currently has $8 million cash. Chelsea...
A: Expected return if Ronaldo is hired by the clubs with weighted average revue under various scenarios...
Q: List the credit bureaus and list information that is contained in a person's credit report.
A: "Hi, Thanks for the Question, Since you asked multiple questions, we will answer first question for ...
Q: Consider 1-factor model and assume that the price of a certain fixed income security P(y) for y=9% 9...
A: To Find: DVO1 Duration Convexity
You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000.
How much downpayment should you put at the time of purchase?
how would i calculate this in excel?
Step by step
Solved in 4 steps with 2 images
- You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Please show your work using excel formulas.You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Plese show your work.You need a 30 year fixed rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6% APR for a 360 month loan. You can only afford a monthly payment of $1000. How much down payment should you put at the time of purchase? Please show work.
- In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase?Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
- Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $ Maximum mortgage at 3%: $I need help solving this on excel 9.You a buying a home for $425,000 and would like to determine the monthly mortgage payment. You can obtain a $340,000 30-year fixed-rate mortgage at 3.5%. What is your monthly payment?You need a 30-year, fixed-rate mortgage to buy a new home for $250,000. Your mortgage bank will lend you the money at an APR of 5.45 percent. However, you can only afford monthly payments of $900, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. How large will this balloon payment have to be for you to keep your monthly payments at $900? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Balloon payment ( Prev 7 of 10 Next
- You are considering purchasing a new home. You will need to borrow AED 4,000,000 to purchase the home. A mortgage company offers you a 10-year fixed rate mortgage at 12% APR. If you borrow the money from this mortgage company, what is your monthly mortgage paymentSuppose you want to purchase a house. Your take-home pay is $4270 per month, and you wish to stay within the recommended guidelines for mortgage amounts by only spending 1/4 of your take-home pay on a house payment. You have $18,500 saved for a down payment and you can get an APR from your bank of 5.7%, compounded monthly. What is the total cost of a house you could afford with a 3030-year mortgage? Round your answer to the nearest cent, if necessary.you are buying a house and will borrow $225,000 on a 30-year fixed reate mortgage with monthly payments to finance the purchase. your loan officer has offered you a mortgage with an APR of 4.3%. Alternatively, she tells you that you can “ buy down ” the interest rate to 4.05% if you pay points up front on the loan is 1 % ( one percentage point) of the loan value. you believe that you will live in the house for only eight years before selling the house and buying another house. this means that in eight years, you will pay off the remaining balance of the original mortgage. how many points, at most, would you be willing to pay to buy down the interest rate? Question) maximum points?