$1$ Using the following tinancial data, complete the balance sheet and sales information. All calculations based on a $365$ day year. Using information from the Balance Sheet tab of the attached Excel sheet, calculate values for the following Balance Sheet and Sales

items:

a$.$ Cash Blank $1$

b$.$ Accounts Receivable Blank $2$

c$.$ Inventories Blank $3$

d$.$ Fixed Assets Blank $4$

e$.$ Sales Blank $5$

f$.$ Current Liabilities Blank $6$

g$.$ Common Stock Blank $7$

h$.$ Total Liabilities and Equity Blank $8$

i$.$ Cost of Goods Sold Blank $9$ Using the information from the Amortization tab of the attached Excel sheet, calculate values for each of the following:

a$.$ What is the monthly payment? Blank $1$

b$.$ What is the beginning balance of the loan for Payment $113?$ Blank $2$

c$.$ What is the beginning balance of the loan for Payment $313?$ Blank $3$

d$.$ What is the amount of interest paid as part of Payment $13?$ Blank $4$

e$.$ What is the amount of interest paid as part of Payment $347?$ Blank $5$

f$.$ What is the amount of principal paid as part of Payment $22?$ Blank $6$

g$.$ What is the amount of principal paid as part of Payment $322?$ Blank $7$

h$.$ What is the ending balance of the loan for Payment $89?$ Blank $8$

i$.$ What is the ending balance of the loan for Payment $289?$ Blank $9$

j$.$ If all payments are made on time and there are no prepayments, what is the total amount paid over the life of the loan? Blank $10$ Construct an amortization schedule for a $$289,000,6,8\%$ nominal rate loan paid monthly for $30$ years. The loan will be fully arnortized. $(20$

points total$)$Using the information from the Amortization tab of the attached Excel sheet, calculate values for each of the following:

a$.$ What is the monthly payment? Blank $1$

b$.$ What is the beginning balance of the loan for Payment $113?$ Blank $2$

c$.$ What is the beginning balance of the loan for Payment $313?$ Blank $3$

d$.$ What is the amount of interest paid as part of Payment $13?$ Blank $4$

e$.$ What is the amount of interest paid as part of Payment $347?$ Blank $5$

f$.$ What is the amount of principal paid as part of Payment $22?$ Blank $6$

g$.$ What is the amount of principal paid as part of Payment $322?$ Blank $7$

h$.$ What is the ending balance of the loan for Payment $89?$ Blank $8$

i$.$ What is the ending balance of the loan for Payment $289?$ Blank $9$

j$.$ If all payments are made on time and there are no prepayments, what is the total amount paid over the life of the loan? Blank $10$Using the information from the Time Value of Money tab of the attached Excel sheet, calculate values for each of the following:

a$.$ If you deposit $$1800$ in an account that pays $3\mathrm{.}75\%$ interest annually, how much will you have after $6$ years? Blank $1$

b$.$ What is the present value of a security that will pay $$42,000$ in $13$ years if securities of equal risk pay $5\mathrm{.}25\%$ annually? Blank $2$

c$.$ You have $$81,455\mathrm{.}75$ in a brokerage account, and you plan to deposit an additional $$22,000$ at the end of each future year until

your account reaches $$500,000.$ You expect to earn $9\%$ annually on the account. How long will it take to reach your goal? Blank $3$

d$.$ You just received an inheritance worth $$200,000.$ You want to retire in $25$ years and you don't plan to make any additional

contributions. If you need $$1,000,000$ in order to retire, what interest rate must you earn in order to reach your goal? Blank $4$

e$.$ An investment will pay $$300$ at the end of each of the next $3$ years, $$150$ at the end of Year $4,$$$500$ at the end of Year $5,$$$700$ at

the end of Year $6,$ and $$400$ at the end of Year $7.$ If other investments of equal risk earn $6\mathrm{.}75\%$ annually, what is the present value of

the cash flow stream? Blank $5$

f$.$ Using the same information from part $e,$ what is the future value of the cash flow stream? Blank $6$

$(18$ points total$)$