Tutors Answer Your Questions about Finance (FREE)
Question 666604: The Acme Company has its European subsidiary based in the Euro zone. The subsidiary must solve a series of five problems that require you to apply the concept of "time value of money," or TVM. The five problems are listed below. Solving them will require the use of Microsoft Excel. Before you begin your work, each student is to select a unique nine-digit random number that contains no zeros, no "patterns," and should use most of the digits between one and nine. This value will be referred to as the student unique number (SUN). Further, digits within the SUN are read from left to right. For example, if the SUN = 123456789, the first digit = 1, the second digit = 2, etc. You are not authorized to use 123456789. To generate a random whole number between 1 and 9, use this excel formula:
=round(8*rand(),0)+1
When you have generated these 9 digits, paste them back onto themselves using the Paste Values option of the Paste command.Please note that the interest rate used in all questions represents an annual rate and all Euro figures are in whole Euros (not Euros and cents).
Acme plans to construct a new manufacturing facility in 14 years. If Acme estimates that today's cost of the new plant is SUN Euros (use all 9 digits) and annual inflation is A% (A = the first digit of SUN), how much will the manufacturing plant cost in 14 years? Give a detailed explanation on your calculations.
Acme has decided to establish a sinking fund for its outstanding preferred stock issue. SUN (use all 9 digits) represents the amount of the issue that will be retired in 26 years. At the beginning of each of these 26 years, Acme will deposit an equal amount into an account that earns B% (B = the second digit of SUN). What is the value of this periodic deposit? Give a detailed explanation on your calculations.
One of Acme's new projects will generate the following cash flows at the end of each of the stated years: year 2 = SUN digits 1-3; year 4 = SUN digits 4-6; year 7 = SUN digits 7-9. If these cash flows are discounted at 12%, what is the sum of their present values? Give a detailed explanation on your calculations.
Acme is assessing its employee pension fund. At the end of each of the next 25 years Acme will have to pay its retirees (use the first 4 digits of your SUN). If the fund is estimated to earn D% (D = the fourth digit of SUN), how much does Acme need to have set aside today to ensure that it can meet its future obligations? (At the end of the 25th year, the balance should be drawn down to zero.) Give a detailed explanation on your calculations.
As part of a new labor contract, Acme has agreed to make a one-time contribution of Euros 1,000,000 to the construction of a new physical fitness facility for its employees. This amount will be placed in an account earning E% (E = the fifth digit of SUN). When the account grows to Euros 1,850,000, construction will commence. How long must employees wait until construction of their new gym begins? (Your answer should be accurate to two decimal places, e.g., 1.57 years). Give a detailed explanation on your calculations.
Prepare for Acme's CFO an analysis that contains solutions for all five problems. Be sure to clearly present and label all values and variables, provide Excel TVM formulas, and conclude each question with a detailed interpretation of your results. Your entire submission must be contained within an Excel document. (Note: You must use Excel TVM functions to complete this assignment; using a hand calculator or website and plugging values into a template is not acceptable.) Note: The books of the subsidiary being held in Euros, the exchange rate Euro/US dollars has no influence on the result of the exercise.
Click here to see answer by lynnlo(4176) |
Question 667223: How many gallons of a 15% salt solution need to be mixed with a 35% salt solution to obtain 8 gallons of 30% salt solution?
Write a system of linear equation that represents this problem situation. Do not solve the system.
Click here to see answer by stanbon(75887) |
Question 669282: your parents are planning to retire in 18 years. They currently have $250,000 and they would like to have $1,000,000 when they retire. What annual rate of interest would they have to earn on their $250,000 in order to reach?
Click here to see answer by stanbon(75887) |
Question 669282: your parents are planning to retire in 18 years. They currently have $250,000 and they would like to have $1,000,000 when they retire. What annual rate of interest would they have to earn on their $250,000 in order to reach?
Click here to see answer by solver91311(24713)  |
Question 669818: A theater seats 990 people. For a sellout performance, full price tickets are $8.50 and student tickets are $4.00. If ticket sales were $6885, then how many student tickets were sold.
I think it starts like this:
6885=8.5(990-y)+4(990-x)
Click here to see answer by ReadingBoosters(3246) |
Question 669779: Two lads played a game in which the winner of each round is awarded a nickel from a referee. When they stop, one lad has won four rounds and the other lad has won 25 cents more than his competitor. How many rounds did they play?
Click here to see answer by Theo(13342)  |
Question 670489: THIS PROBLEM MUST BE SOLVED USING SYSTEMS.
The manager of a candy shop sells chocolate covered peanuts for $7 per pound and chocolate covered cashews for $14 per pound. The manager wishes to make a 245-pound cashew-peanut mixture that will sell for $9 per pound. How many pounds of each should be used?
Click here to see answer by mananth(16946)  |
Question 672047: Workout Plus offers a membership for $30 each month plus a $100 start up fee. Fit works offers a membership for $50 each month plus a $20 start up fee. After how many months will memberships to both gyms cost the same amount?
Click here to see answer by stanbon(75887) |
Question 672373: cho sasaki demonstrates microwave ovens at the national home show she is paid $7 for each of the first 7 demonstations and $11 for each demonstration for each demonstration over 7 what is her commision for a day in which she makes 12 demonstrations
Click here to see answer by checkley79(3341) |
Question 673265: b. Game Central sells previously owned xbox games for $10 and new xbox games for $55. Last month, their store in Pittsburgh, Pennsylvania had total sales of these two items of $31,845. Customers bought 4 times as many new video xbox games than used games. How many of each item did Game Central sell?
31,845=10(x)+55(y)
and
4(x)=y
Click here to see answer by edjones(8007)  |
Question 674329: I need step by step breakdown on the following; solve for EBIT
(ebit-4000)(1-0.5)-0 / 2000 = (ebit-8250)(1-0.5)-0 / 1500. My text states the answer is 21000, which pans out, but it doesn't show the work it used to come up with the answer
Click here to see answer by ewatrrr(24785)  |
Question 675210: Hi there, I keep getting the wrong answer €6,235.10 to this question. What am I doing wrong? I divided the interest by 4 and the year by 4.
Question: A person saves €4,429 in a bank account at the end of each quarter. The bank offers a return of 4.3% p.a compounded quarterly. How much will this investment be worth after 8 years?
Click here to see answer by Edwin McCravy(20055)  |
Question 675252: I really need help. I do not understand how to solve this at all:
A man invests his savings in 2 accounts, one paying ^5 per year and the other %. He has twice as much invested in the 7% account as in the 6% account, and his annual interest income is $600. How much is invested in each account?
Click here to see answer by ReadingBoosters(3246) |
Question 581601: Templeton Extended Care Facilities, Inc. is considering the acquisition of a chain of cemeteries for $450 million. Since the primary asset of this business is real estate, Templeton’s management has determined that they will be able to borrow the majority of the money needed to buy the business. The current owners have no debt financing but Templeton plans to borrow $340 million and invest only $110 million in equity in the acquisition. What weights should Templeton use in computing the WACC for this acquisition?
Click here to see answer by mom 48(1) |
Question 678657: Alex earns $55,000 as a salesman. he also earns $100 per a month if he reaches his sales goal. Write An Algebraic expression to show the total amount he expects to get paid if he gets his bonus after M months
Click here to see answer by stanbon(75887) |
Question 678904: An elevator can carry up to 2,500 lbs. Suppose the weight of an average adult is 150lbs. and a child is 70lbs. At most, how many average- sized adults can safely ride the elevator at the same time if there are three children? show your work.
Click here to see answer by unlockmath(1688)  |
Question 678904: An elevator can carry up to 2,500 lbs. Suppose the weight of an average adult is 150lbs. and a child is 70lbs. At most, how many average- sized adults can safely ride the elevator at the same time if there are three children? show your work.
Click here to see answer by jim_thompson5910(35256) |
Question 678911: Two friends are renting an apartment. They pay the landlord the first month's rent. The landlord also requires them to pay an additional halfof month's rent for a security deposit.The total amount they pay the landlord before moving in is $1725. What is the monthly rent? show your work to support your answer.
Click here to see answer by ReadingBoosters(3246) |
Question 683334: Please I need help with the following question:
* Determine the annual payment on a $15,000 loan that is to be amortized over a four-year period and carries 10 percent interest rate. Also prepare a loan amortization schedule for this loan.
p = $15,000
r = $10%
t = 4 years (Compound annually)
FV = $15,000 (1 + 0.1)4
FV = $15,000 (1.4641)
FV = $21,961.5
DATA LOAN
Original Principle $15,000.00
Loan Term (Years) 4
Annual Interest Rate 10%
Payments per Year 12
Payments $4,732.06
(Note: I don't no how to calculate the principle)
year payment principle Interest Balance
0 $15,000
1 $4,732.06 $1,500.00
2 $4,732.06
3 $4,732.06
4 $4,732.06
Click here to see answer by solver91311(24713)  |
Question 683559: Hi this is just a simple algebra equation , I know the answer but I just can't figure out the steps, it's been a while since I've done a math course.
6.5%=(10,000-P)/P * 365/180
solve for P
the answer is:
P = 9,689,408
thank you for anyone who takes the time to answer this
Click here to see answer by vtjimmy(2) |
Question 683559: Hi this is just a simple algebra equation , I know the answer but I just can't figure out the steps, it's been a while since I've done a math course.
6.5%=(10,000-P)/P * 365/180
solve for P
the answer is:
P = 9,689,408
thank you for anyone who takes the time to answer this
Click here to see answer by MathTherapy(10552)  |
Question 685737: 5 average office workers earn a total average monthly salary of $10,000.If the average salary of two of these workers total $13,000,what is the average monthly income of the remaining three workers?
Click here to see answer by sachi(548)  |
|
Older solutions: 1..45, 46..90, 91..135, 136..180, 181..225, 226..270, 271..315, 316..360, 361..405, 406..450, 451..495, 496..540, 541..585, 586..630, 631..675, 676..720, 721..765, 766..810, 811..855, 856..900, 901..945, 946..990, 991..1035, 1036..1080, 1081..1125, 1126..1170, 1171..1215, 1216..1260, 1261..1305, 1306..1350, 1351..1395, 1396..1440, 1441..1485, 1486..1530, 1531..1575, 1576..1620, 1621..1665, 1666..1710, 1711..1755, 1756..1800, 1801..1845, 1846..1890, 1891..1935, 1936..1980, 1981..2025, 2026..2070, 2071..2115, 2116..2160, 2161..2205, 2206..2250, 2251..2295, 2296..2340, 2341..2385, 2386..2430, 2431..2475, 2476..2520, 2521..2565, 2566..2610, 2611..2655, 2656..2700, 2701..2745, 2746..2790, 2791..2835, 2836..2880, 2881..2925, 2926..2970, 2971..3015, 3016..3060, 3061..3105, 3106..3150, 3151..3195, 3196..3240, 3241..3285, 3286..3330, 3331..3375, 3376..3420, 3421..3465, 3466..3510, 3511..3555, 3556..3600, 3601..3645, 3646..3690, 3691..3735, 3736..3780, 3781..3825, 3826..3870, 3871..3915, 3916..3960, 3961..4005, 4006..4050, 4051..4095, 4096..4140, 4141..4185, 4186..4230, 4231..4275, 4276..4320, 4321..4365, 4366..4410, 4411..4455, 4456..4500, 4501..4545, 4546..4590, 4591..4635, 4636..4680, 4681..4725, 4726..4770, 4771..4815, 4816..4860, 4861..4905, 4906..4950, 4951..4995, 4996..5040, 5041..5085, 5086..5130, 5131..5175, 5176..5220, 5221..5265, 5266..5310, 5311..5355, 5356..5400, 5401..5445, 5446..5490, 5491..5535, 5536..5580, 5581..5625, 5626..5670, 5671..5715, 5716..5760, 5761..5805, 5806..5850, 5851..5895, 5896..5940, 5941..5985, 5986..6030, 6031..6075, 6076..6120, 6121..6165, 6166..6210, 6211..6255, 6256..6300, 6301..6345, 6346..6390, 6391..6435, 6436..6480, 6481..6525, 6526..6570, 6571..6615, 6616..6660, 6661..6705, 6706..6750, 6751..6795, 6796..6840, 6841..6885, 6886..6930, 6931..6975, 6976..7020, 7021..7065, 7066..7110, 7111..7155, 7156..7200, 7201..7245, 7246..7290, 7291..7335, 7336..7380, 7381..7425, 7426..7470, 7471..7515, 7516..7560, 7561..7605, 7606..7650, 7651..7695, 7696..7740, 7741..7785, 7786..7830, 7831..7875, 7876..7920, 7921..7965, 7966..8010, 8011..8055, 8056..8100, 8101..8145, 8146..8190, 8191..8235, 8236..8280, 8281..8325, 8326..8370, 8371..8415, 8416..8460, 8461..8505, 8506..8550, 8551..8595, 8596..8640, 8641..8685, 8686..8730, 8731..8775, 8776..8820, 8821..8865, 8866..8910, 8911..8955, 8956..9000, 9001..9045, 9046..9090, 9091..9135, 9136..9180, 9181..9225, 9226..9270, 9271..9315, 9316..9360, 9361..9405, 9406..9450, 9451..9495, 9496..9540, 9541..9585, 9586..9630, 9631..9675, 9676..9720, 9721..9765, 9766..9810, 9811..9855, 9856..9900, 9901..9945, 9946..9990, 9991..10035, 10036..10080, 10081..10125, 10126..10170, 10171..10215, 10216..10260, 10261..10305, 10306..10350, 10351..10395, 10396..10440, 10441..10485, 10486..10530, 10531..10575, 10576..10620, 10621..10665, 10666..10710, 10711..10755, 10756..10800, 10801..10845, 10846..10890, 10891..10935, 10936..10980, 10981..11025, 11026..11070, 11071..11115, 11116..11160, 11161..11205, 11206..11250, 11251..11295, 11296..11340, 11341..11385, 11386..11430, 11431..11475, 11476..11520, 11521..11565, 11566..11610, 11611..11655, 11656..11700, 11701..11745, 11746..11790, 11791..11835, 11836..11880, 11881..11925, 11926..11970, 11971..12015, 12016..12060, 12061..12105, 12106..12150, 12151..12195, 12196..12240, 12241..12285, 12286..12330, 12331..12375, 12376..12420, 12421..12465, 12466..12510, 12511..12555, 12556..12600, 12601..12645, 12646..12690, 12691..12735, 12736..12780, 12781..12825, 12826..12870, 12871..12915, 12916..12960, 12961..13005, 13006..13050, 13051..13095, 13096..13140, 13141..13185, 13186..13230, 13231..13275, 13276..13320, 13321..13365, 13366..13410, 13411..13455, 13456..13500, 13501..13545, 13546..13590, 13591..13635, 13636..13680, 13681..13725, 13726..13770, 13771..13815, 13816..13860, 13861..13905, 13906..13950, 13951..13995, 13996..14040, 14041..14085, 14086..14130, 14131..14175, 14176..14220, 14221..14265, 14266..14310, 14311..14355, 14356..14400, 14401..14445, 14446..14490, 14491..14535, 14536..14580, 14581..14625, 14626..14670, 14671..14715, 14716..14760, 14761..14805, 14806..14850, 14851..14895, 14896..14940, 14941..14985, 14986..15030, 15031..15075, 15076..15120, 15121..15165, 15166..15210, 15211..15255, 15256..15300, 15301..15345, 15346..15390, 15391..15435, 15436..15480, 15481..15525, 15526..15570, 15571..15615, 15616..15660, 15661..15705, 15706..15750, 15751..15795, 15796..15840, 15841..15885, 15886..15930, 15931..15975, 15976..16020, 16021..16065, 16066..16110, 16111..16155, 16156..16200, 16201..16245, 16246..16290, 16291..16335, 16336..16380, 16381..16425, 16426..16470, 16471..16515, 16516..16560
|