solve theses question??
Q#l Sandy, a manufacturing engineer, just received a year-end bonus of $10,000 that will be invested immediately. With the expectation of earning at the rate of 8% per year, Sandy hopes to take the entire amount out in exactly 20 years to pay for a family vacation when the oldest daughter is due to graduate from college. Find the amount of mds that will be available in 20 years by using (a) hand solution by applying the factor formula and tabulated value and (b) a spreadsheet mction. Q # 2 Once again, consider the HAC case presented at the outset of this chapter, in which a projected $200 million investment can generate $50 million per year in revenue for 5 years starting 1 year after start-up. A 10% per year time value of money has been used previously to determine 1;, F , and A values. Now the president would like the answers to a couple of new questions about the estimated annual revenues. Use tabulated values, factor formulas, or spreadsheet functions to provide the answers. ( a ) What is the equivalent iture worth of the estimated revenues after 5 years at 10% per year?I Q) Assume that, due to the economic downturn, the president predicts that the corporation will earn only 4.5% per year on its money, not the previously anticipated 10% per year. What is the required amount of the annual revenue series over the 5-year period to be economically equivalent to the amount calculated in (3 )? Q # 3 Determine the P_A factor value for i,_ 7.75% and n _ 10 years, using the three methods described previously. Q # 4 A local university has initiated a logo-licensing program with the clothier W Inc. Estimated fees (revenues) are $80,000 for the 11 rs; year with uniform increases to a total of $200,000 by the end of year 9. Determine the gradient and construct a cash ow diagram that identies the base amount and the gradient series. Q # 5 Neighboring parishes in Louisiana have agreed to pool road tax resources already designated for bridge refurbishment. At a recent meeting, the engineers estimated that a total of $500,000 will be deposited at the end of next year into an account for the repair of old and safetyquestionable bridges throughout the area. Further, they estimate that the deposits will increase by $100,000 per year for only 9 years thereafter, then cease. Determine the equivalent (a) present worth and (9) annual series amounts. if public funds earn at a rate of 5% per year. Q # 6 The announcement of the HAC cement factory states that the $200 million (M) investment is planned for 2012. Most large investment commitments are actually spread out over several years as the plant is constructed and production is initiated. Further investigation may determine, for example, that the $200 M is a present worth in the year 2012 of anticipated investments during the next 4 years (2013 through 2016). Assume the amount planned for 2013 is $100 M with constant decreases of $25 M each year thereafter. As before, assume the time value of money for investment capital is 10% per year to answer the following questions using tabulated factors and spreadsheet functions, as requested below
