I need help here with the questions, calulaction in excel, excelformulas and answers for the questions on this spreadsheet before this Friday at 600pm. Can you make it happen on time plus with the excel spreadsheet formulas for each. Thank you

Midterm Exam, Summer 2016 Name Question 1 2 3 4 5 6 7 8 9 10 Late Total Score 0 0 0 0 0 0 0 0 0 0 0 0 Question 1 Score 0 Johnathon and Maria want to buy a modest "starter" home. They have $10,000 in a savings account and they want to increase this to $50,000 to use as a down payment. They checked an online bank and found the following three options for saving these funds, each with different rates and requirements. How much would they have to deposit monthly in each account to get to their goal in five years? a b c Solution A savings account could be accessed at any time but only offers 1.00% NAR with daily compounding. A Money Market requires a minimum balance of $10,000, that they have, and has a rate of 1.5% NAR with monthly compounding. A Certificate of Deposit (CD), that has limited withdrawal frequencies, and currently has an NAR of 1.25% with quarterly compounding. Question 2 Score 0 Nina is retiring and has sold her home and now has $800,000 total retirement savings. She plans to move into a retirement center. Her planning horizon is 20 years. Assume end of period payments. What nominal annual rate of interest from a fund that compounds monthly would she need if she has to pay the a monthly $3,000 retirement center fee plus needs $1,000 monthly for other expenses,without reducing the fund balance. What nominal annual rate of interest from a fund that compounds monthly would she need if she has $100,000 at the b end of 20 years, immediately spends $5,000 on a vacation, and withdraws $4,000 at the end of each month. Solution Question 3 Score 0 Larry created an education fund for his daughter that has a NAR with monthly compounding of 1 3/8% (=1.375%). Today is December 31 and the balance is $70,000. a If $1,500 is withdrawn on the last day of each upcoming month, what would be the balance on the loan at the end of four years? b If $4,500 is withdrawn on the last day of each upcoming quarter, what would be the balance on the loan at the end of four years? Solution Question 4 Score 0 Easy-Loans, Inc. will make a pay-day loan at a charge of 5% for a two-week loan. a b Solution What is the effective annual rate of the loan? If, instead of paying off the loan every two weeks, a new loan is taken out with the new loan amount being the previous loan plus interest, what will be the balance of the loan at the end of one year? Question 5 Score 0 Diane runs a summer camp for kids. Diane is getting older and has allocated $5 million to fund the future expenses of the camp, that will be in an account that pays 3.5% NAR with monthly compounding. At the end of each year, funds will be withdrawn from the fund and put in the camps interest bearing checking account that has an NAR of .75% with monthly compounding. Assume that equal monthly payments will be withdrawn from this account at the beginning of each month. If the funding is intended to last forever, how much will the camp have at the beginning of each month for expenses? Solution Question 6 Score 0 BioProduction, Inc. is considering a new automated production capability that would result in $250,000 of added annual income after put in use. It is expected to cost $350,000 annually for three years to develop this new capability, and a one time investment of $500,000 for implementation in the 3rd year of development. Assume all costs and income are end-of-year values. How many years after the process in implemented would it take for the added revenues to cover the production costs incurred in the first three years. BioProduction, Inc. considers the time value of money in all financial analyses using a 6% effective annual rate of interest. Solution Question 7 Score 0 Nellie inherited $90,000 and is going to invest this. She has narrowed the options to a bond and a stock. a Determine the effective annual rate of return of each based on the data below. b What else besides the EARs could affect her decision between the bond and the stock? Bond Stock Purchase $90,000 Purchase pr $90,000 price Face value $100,000 Forecasted 5% annual % increase Maturity 10 years from Expected d $1,000 total for all shares Coupon Frsemi-annual Dividend f quarterly Coupon 6.25% semi-annuaTime horiz 10 years Rate Solution Question 8 Score 0 Katrina will retire soon from her accounting position and is looking for a small retirement business. Her present company has a new customer who has special cleanliness requirements and her company would have a hard time accomplishing this in their present environment. Katrina is considering starting a small LLC that would do the packaging for them for a fee. This seems to be advantageous for both the company and for Katrina. She has found a facility to rent that can meet the cleanliness requirement. She has collected the data shown below. Price $10 Facility ren $20,000 Equipment $450 Utilities $800 Packaging m $0.50 Labor $1.00 each annually monthly monthly each each b If the quantity is 7000 units annually, what would be the annual profit? What is the break even quantity for the $10 price? c What is the breakeven price for the quantity of 7,000? a Solutions Question 9 Score 0 The Ceynar Company, Inc. has finished their accounting statements except for the working capital considerations. Alter the financial statements shown below to include the following working capital data. Beginning of Year Inventory$1,008 Inventory$3,330 Accounts R $5,968 Accounts P $8,300 Wages Paya $450 Taxes Payab $600 Income Statement Revenue Material Co$720,000 Labor Cost $456,000 Overhead $282,240 COGS Gross Margin Executive & ### Facility Ma $800,000 Marketing $900,000 S.G.&A. Depreciation EBIT Interest Pre-Tax Income Taxes Net Income End of Year $1,800 $4,100 $6,250 $5,750 $650 $1,090 $6,626,104 ($1,458,240) $5,167,864 ($3,900,000) ($325,000) $942,864 ($145,000) $797,864 ($111,470) $686,394 Cash Flow Statement Net income Depreciation Change in Working Capital Total Capital Expenditure Asset Purchase Asset Sale Total Financial activities Dividends Loan Principal Paymen Total Net Change in cash Beginning Cash Balance Ending Cash Balance Balance Sheets Assets Current Assets Cash $426,394 Inventory$1,008 Inventory$3,330 Accounts R $5,968 Total $436,700 Long term Assets Equipment $11,050 Building $3,860 Land $4,040 Total Total Assets $18,950 $455,650 Solution Liabilities and Owners' Equity Current liabilities Accounts P $8,300 Wages Paya $450 Taxes Payab $600 Total Long term liabilities Loans - Lon $1,500 Bonds $6,100 Total Stockholders Equity Stock $26,800 Retained E $411,900 Total Liabilities and Owners' Equity $686,394 $325,000 $0 $1,011,394 ($87,000) $54,000 ($33,000) ($300,000) ($400,000) ($700,000) $278,394 $148,000 $426,394 and Owners' Equity $9,350 $7,600 $438,700 $455,650 coffee machine and says, "The Write an people in explanatio the new n for the 1Score Question company general keeps manager talking using an about this example(s "present ). Limit value" this to thing, 500 and you words. mentione Post this d inthis the in the space meeting below or yesterday in a ?separate You have all MS Word those document degrees . that I paid for, so explain this to me clearly in terms I can understan d, and not with quotes from a textbook or website." 0