Question

Overview: You just began a position as a financial accountant at Peyton Approved. In this role, your first task is to prepare the company’s financials for the year-end audit. Additionally, the company is interested in expanding its business within the next year. They would like your support in assessing their ability to meet their goals.

Refer to the data below and use the Final Project Workbook that includes the income statement, balance sheet, retained earnings statement and cash flow statement to complete the final project and associated milestones.

Peyton Approved Financial Data: Preliminary Financial Statements have already been prepared (2017 statements in the Final Project Workbook). Final adjusting entries have not yet been made. See table for possible adjustments that indicate what will be recorded at 12/31/17 (fiscal year end). Use the following to complete year-to-year documentation and notes for managing depreciation, inventory, and long-term debt.

A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for the goods, as well as a bill for freight for $175, all dated 12/29/17. Goods were shipped FOB supplier’s warehouse.

At 12/31/17, Peyton has $200 worth of merchandise on consignment at Bruno’s House of Bacon.

On 12/23/17, Peyton received $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January.

On 12/03/2017, a mixer with a cost of $2,000, accumulated depreciation $1,200, was destroyed by a forklift. As of 12/23/17, insurance company has agreed to pay $700 in January, 2018, for accidental destruction.

Note about later borrowing - financials will show loan from parents repaid and use of bank financing.

The company is planning to open another location in 2018. Prepare pro forma financials for 2018 for the new location using the following information:

Cost of leasing commercial space: $1,500 per month.

Cost of new equipment: $15,000, purchased with a long-term note. Use straight line depreciation assuming a seven-year life, no residual value. Use full year’s depreciation for the first year.

Cost of hiring and training new employees: three at $25,000 each for the first year.

Except as noted below, assets, current liabilities, sales, costs, and expenses are expected to be 80% of the existing store (from preliminary statements) except no stock. Retained earnings = net income.

Cash: $7,000. Accounts receivable amount to 4.0 turns (accounts receivable turnover will be 4.0); inventory amount to show 3.0 turns (inventory turnover will be 3.0). No stock will be issued. Retained earnings are to equal net income. Additional financing of $5,000 will be long-term. Add remaining amount needed to balance into accounts payable.

Please help me prepare the revised cash flow sheet as well as the ratio analysis sheet.

Statement of cash Flow For Year Ended 12/31/2017 Statement of cash Flow For Year Ended 12/31/2017 Net Income $ 175,576.18 677.86 Net Income Depreciation Expense Depreciation Expense 176,254.04 Increase in Accounts Receivable Increase in Baking Supplies Increase in Merchandise inventory Increase in Prepaid Rent Increase in Prepaid Insurance Increase in Misc Supplies Increase in Accounts Payable Increase in Wages Payable Increase in Interest Payable (25,886.91) (8,187.84) (443.10) 449.55) (1,004.55) (114.99) 3,292.11 1850.48 44.96 Increase in Accounts Receivable Increase in Baking Supplies Increase in Merchandise i Increase in Prepaid Rent Increase in Prepaid Insurance Increase in Misc. Supplies Increase in Accounts Payable Increase in Wages Payable Increase in Interest Payable Operating Cash Flow 145,354.65 Operating Cash Flow Cash Flow from Investments Equipment Purchases Cash Flow from Investments Equipment Purchases (6,000.00) Cash Flow from Investments (6,00000) Cash Flow from Investments Cash Flow from Financing Repayment of Note Payable Dividends Paid (10,000.00) 105,000.00) Cash Flow from Financing Repayment of Note Payable Dividends Paid Cash Flow from Financing 115,000 00) 24,354 65 43,165 39 67,52004 Cash Flow from Financing Net Cash Flow Net Cash Flow Beginning Cash Beginning Cash Ending Cash Ending Cash 2017 2016 Current Ratio (Working Capital) Quick Ratio R Turnover Inventory Tumover Gross margin Return on Sales Return on Equity Return on Assets

Answer 1

solution :

given that Rundle Freight Company owns a truck that cost $33,000.

also given that Currently, the truck’s book value is $27,000, and its expected remaining useful life is five years

mentioned in gi ven indormation that

Rundle has the opportunity to purchase for $28,000 a replacement truck that is extremely fuel efficient. Fuel cost for the old truck is expected to be $7,000 per year more than fuel cost for the new truck.

some other given information The old truck is paid for but, in spite of being in good condition, can be sold for only $16,000.

Calculating the total relevant costs:

	retaining truck	replacing truck
cost of the new truck	$-	$28000
additional fuel cost (5*7000)	$35000	$-
oppurtunity cost	$16000	$-
total cost	$51000	$28000

final decision of retaining old truck :

the purchase cost of ol;d truck and book value are irrelevant

they are sunk cost

therefore they should not be considered

the comparision cost of replacing and retaining truck are given above

from the above table

the company should replace the old truck as it would cost $28000 in replacement as against the cost of reraining truck of $51000