Answers
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
ONLY FINANCIAL FORMULA. NO EXCEL FUNCTION IS USED. JUST WRITTEN IN EXCEL.
x 9 VOL pravi mardura PV, PV, ANNUITY (Autosaved) - Excel 08:53 ENG 03 01 2020 - 6 x Share u 21 e 9 W OS File Home Insert Page Layout romulas Data Review View Help for 2*2 AIRB Insert AutoSur Recently Financial Logical Text Date & Lookup & Math & More Function - Used - - - Time- ReferenceTrig - Functions Functon Library Calculate Now Tell me what you want to do Define Name Y Use in Formula - Name Manager Create from Selection Dahned Names Trace Precedents Show Formulas Trace Dependents Error Checking - Remiore Arrows- ws" Evaluate Fermula Evaluate Formula Formula Auditing Watch Window Window Calculation Calculate Sheet Options Calculation CX105 EX FA EY STEP 1 FB FC FD FE F E STOCK ACCOUNT PMT RATE YEARS MONTHLY RATE NO OF MONTHS ORDINARY ANNUITY 1400 10% 20 0.83333333% 240 FUTURE VALUE = FUTURE VALUE = FUTURE VALUE = PMT (1/r)*((1+r)^n - 1) 1400*(1/0.0083333333)*((1+0.0083333333)^240 - 1) 1063116.36 STEP 2 ORDINARY ANNUITY 1100 5% BOND ACCOUNT PMT RATE YEARS MONTHLY RATE NO OF MONTHS 0.41666667% 240 104 105 106 FUTURE VALUE = FUTURE VALUE = FUTURE VALUE = PMT*(1/r)*((1+r)^n - 1) 1100*(1/0.00416666667)*((1+0.00416666667)^240 - 1) 452137.04 CAP STRU VALUE | PM, PMI loan with points LOCK BOX DILUTION DOLLAR COSI AVG EXPO NPER APR CPI ear FVA pva 52 53 STATE S6 S7 ...
Pv, fv, annuity Circular References S8 ... P L A -+ 130 Ready -_
08:54 W V a L A4% 2 pravi mandura u 21 e 9 OS Tile Home Interit Page Layout Formulas Data Review View for 2*2 AIRB ENG 03 01 2020 - 6 X Share Help PV, PV, ANNUITY (Autosaved) - Excel Tell me what you Define Name Trace Precedents Show Formulas Y Use in Formula - Trace Dependents Error Checking - Name Manager Create from Selection Remiore Arrows- ws" Evaluate Fermula Evaluate Formula Dahned Names Formula Auditing Calculate Now Insert Function AutoSur Recently Financial Logical Text Date & Lookup & Math & More - Used - - - Time- ReferenceTrig - Functions Functon Library Watch Window Window Calculation Calculate Sheet Options Calculation EX127 EX EY EZ FA FB FC FD FE F F 106 107 STEP 3 TOTAL ACCUMULATED AMOUNT 1515253.40 (1063116.36+ 452137.04) 108 STEP 4 109 110 THE ABOVE ACCUMULATED AMOUNT WILL BECOME "PRESENT VALUE" WE HAVE TO FIND HOW MUCH CAN BE WITHDRAWAN MONTHLY 111 112 STEP 5 7% 25 ORDINARY ANNUITY RATE YEARS MONTHLY RATE NO OF MONTHS PV = 0.58333333% 300 1515253.40 113 114 115 116 117 118 119 120 121 122 123 124 125 126 PRESENT VALUE = 1515253.40 = 1515253.40 = PMT = ANSWER PMT= PMT*(1/r)*(1-(1/(1+r)^n)) PMT*(1/0.00583333333)*(1-(1/(1+0.00583333333)^300)) PMT* 141.4869034 1515253.40/141.4869034 10709.50 127 L CAP STRU VALUE PM, PMI loan with points LOCK BOX DILUTION DOLLAR COSI AVG EXPO NPER APR CPI ear FVA pva 52 53 STATE 56 57 L ... pv, fv, annuity Circular References 58 ... O P Ready -_ -+ 130
.
Similar Solved Questions
1 answer
Question 3 According to Amazon's 2017 10 K filing report, what are the largest line items...
Question 3 According to Amazon's 2017 10 K filing report, what are the largest line items that make up their assets (as a % of total assets) and what does this tell you about the company structure?...
1 answer
A benefit of a gross lease is that it is easy for the tenant to forecast...
A benefit of a gross lease is that it is easy for the tenant to forecast expenses related to the use of the property. True or False In a gross lease, the rent is all-inclusive. The tenant pays all or most expenses associated with the property, including taxes, insurance, and maintenance on top of th...
1 answer
Juniper Corp. makes three models of insulated thermos. Juniper has $400,000 in total revenue and total...
Juniper Corp. makes three models of insulated thermos. Juniper has $400,000 in total revenue and total variable costs of $240,000. Its sales mix is given below Percentage o total sales Thermos A Thermos B Thermos C 35% 45 20 Required 1. Calculate the (overall) weighted-average contribution margin ra...
1 answer
How do you use the binomial theorem to calculate #1.01^5# ?
How do you use the binomial theorem to calculate #1.01^5# ?...
1 answer
What is the obligation of society to provide health care goods and services to the extent...
What is the obligation of society to provide health care goods and services to the extent of its resources?...
1 answer
A bank has a reserve requirement of 50% and no excess reserves. If a new customer...
A bank has a reserve requirement of 50% and no excess reserves. If a new customer deposits $100 million, the bank can make a maximum new loan of: $10 million $50 million $90 million $100 million...
1 answer
Why can’t a work of art have both intrinsic and instrumental value?
Why can’t a work of art have both intrinsic and instrumental value?...
1 answer
Hotchkiss Company has two support departments, Maintenance Department (MD) and Personnel Department (PD), and two producing...
Hotchkiss Company has two support departments, Maintenance Department (MD) and Personnel Department (PD), and two producing departments, P1 and P2. The Maintenance Department costs of $90,000 are allocated on the basis of standard service hours used. The Personnel Department costs of $9,000 are allo...
1 answer
Kingbird Company determined its ending inventory at cost and at LCNRV at December 31, 2020, December...
Kingbird Company determined its ending inventory at cost and at LCNRV at December 31, 2020, December 31, 2021, and December 31, 2022, as shown below. Cost NRV 12/31/20 $707,100 $707,100 12/31/21 807,500 741,400 12/31/22 850,600 777,300 ...
1 answer
1. The nurse is evaluating the vital signs of an obstetric patient in preterm labor who...
1. The nurse is evaluating the vital signs of an obstetric patient in preterm labor who has recently begun taking terbutaline (Brethine). The patient reports that her heart feels like it is racing and questions if this is a normal feeling. Provide a response for the patient to include drug education...
1 answer
You have a certain amount of a gas at 1000 space P a, in a container...
You have a certain amount of a gas at 1000 space P a, in a container of 30 space m a cube, on a hot day in which to make 27 high at oo C. This gas is compressed undergoing a capital temperature gradient delta T equal to 23 C raised to or, and reaching a pressure of 1615 space Pa. Determine the final...
1 answer
Solve the following system by the elimination method. -2x+14-8y Select the correct choice below and, if...
Solve the following system by the elimination method. -2x+14-8y Select the correct choice below and, if necessary, fill in the answer box to complete your choice. O A. The solution is O B. There are infinitely many solutions. (Simplify your answer. Type an ordered pair) ° C. There is no solution...
1 answer
The supply of labor (input for production) in an organization from 100 to 150 and the...
The supply of labor (input for production) in an organization from 100 to 150 and the price of labor decreased from $20.00 to $25.00. Calculate the price elasticity of supply....
1 answer
1. A proposed mechanism for a reaction is: 1221 (rapid equilibrium) I + H2 = H2...
1. A proposed mechanism for a reaction is: 1221 (rapid equilibrium) I + H2 = H2 (rapid equilibrium) H21 + 1 = 2 HI (slow) a. Write the overall balanced equation for this reaction. (4 pts.) b. Indicate which step is the rate determining step. (1 pt.) c. Based on the mechanism proposed, write the rate...
1 answer
Jestion 39 In STR, stuttering is an example of which of the following: O A. Amplification...
Jestion 39 In STR, stuttering is an example of which of the following: O A. Amplification artifacts B. Allelic dropout O C. Spikes OD. All of the above...
1 answer
The following information is from ABC Company's general ledger: Beginning and ending inventories, respectively, for raw...
The following information is from ABC Company's general ledger: Beginning and ending inventories, respectively, for raw materials were $16,000 and $20,000 and for work in process were $40,000 and $44,000. Raw material purchases and direct labor costs incurred were $72,000 each, and manufacturing...
1 answer
Homework problem I am having difficulty with!
A 9.0-kg hanging weight is connected by a string over a pulley to a 5.0-kg block sliding on a flat table. If the coefficient of kinetic friction is 0.20, find thetension in the string....