baogiatrinh
2: A. Use Microsoft Excel to construct a Transactions Journal….
2: A. Use Microsoft Excel to construct a Transactions Journal. Enter Transactions a to k
in the Transactions Journal. Construct the Balance Sheet and Income Statement,
shown in the chapter. Create links between the Transactions Journal and the
financial statements to carry forward the accounting figures.
B. Analyze the financial statements displayed by calculating the Current Ratio,
Working Capital, Solvency, and Profitability. Is the business liquid, solvent, and
profitable?
Image transcription text
A B C D E F G 1 TRANSACTIONS JOURNAL 2 TRANSACTIONS
DATE MEMO ACCOUNT ACCOUNT TYPE DEBIT CREDIT 15
Invested Cash Cash Asset 6 Paid-in Capital Equity $ 1…
Show more
Image transcription text
A B 1 BALANCE SHEET 2 ASSETS 3 Current Assets 4 Cash in
Bank 5 Accounts Receivable 6 Inventory 7 Total Current Assets 8
9 Fixed Assets 10 Equipment 11 Total Fixed Assets 12 …
Show more
Image transcription text
A B 1 INCOME STATEMENT 2 REVENUE 3 Sales in 4 Total
Revenue 6 COST OF GOODS SOLD 7 Inventory Purchases 8
Wages 9 Total Cost of Goods Sold 10 11 Gross Margin …
Show more
Image transcription text
Balance Sheet (Jan 1) Current Assets 400,000 Current Liabilities
100,000 Fixed Assets 600,000 Term Liabilities 400,000 Total
Assets 1,000,000 Total Liabilities 500,000 Equity 500,…
Show more
3: A. Draw the line diagram in Microsoft Excel that shows the cost of extra effort (c(e+),
where e>10) that forms the base for the described employee incentive contract.
5: A. Construct an Excel model with a solver to solve for the profit-maximizing levels of
price and quantity for the profit function, Z = qp – cf – qcv, where cf = 8000, cv = 6,
and the demand function for the product is q = 2400 – 24p. Illustrate the solution
with a graph of the profit function, showing the profit-maximizing price level.
6: A. Calculate the value at the end of the tenth year of a one-time payment of
100,000 invested at an annualized return of 16 percent. Returns are compounded
annually.B. Calculate the value at the end of the tenth year of a one-time payment of
100,000 invested at an annualized return of 16 percent. Returns are compounded
quarterly.
C. Calculate the value at the end of the fifth year of an annuity paid where 100,000
is paid at the end of each year at an annualized return of 16 percent. Returns are
compounded annually.
D. Calculate the present value of 100,000 to be received at the end of 10 years using
an annualized discount rate of 16 percent. Returns are compounded annually.
E. Calculate the present value of 100,000 to be received at the end of 10 years using
an annualized discount rate of 24 percent. Returns are compounded annually.
F. Calculate the present value of an annuity where 100,000 is received at the end of
each of the next five years using a discount rate of 16 percent. Returns are
compounded annually.
G. Construct a Microsoft Excel worksheet to determine whether or not the farmer
should make the following investment: A farmer is thinking of purchasing a
combine solely to do custom combining for neighboring farms. It is a means of
creating an income stream for his son. The combined costs are 400,000 and will result
in annual cash inflows of 180,000 and annual cash outflows of 40,000. The
combine will be used for three years and then sold for an estimated salvage value of
166,600. The CCA rate is 30 percent, the farm’s marginal tax rate is 25 percent,
and the required return (discount rate) for the investment is 12 percent
That is all I have
thank you for your help
