Go SUB TO MY YT CHANNEL Florida_kik For a

Marta communications, inc. has provided incomplete financial statements for the month ended march 31. the controller has asked you to calculate the missing amounts in the incomplete financial statements. use the information included in the excel simulation and the excel functions described below to complete the task

Selected t-account balances for bloomfield company are shown below as of january 31, which reflect its accounting adjustments. the firm uses a calendar-year accounting period, but prepares monthly accounting adjustments.suppliesjan. 31 bal. 1,800 1,800 jan. 31 bal.supplies expensejan. 31 bal. 1,920 1,148 jan. 31 bal.prepaid insurancejan. 31 bal. 1,148 1,148 jan. 31 bal.insurance expensejan. 31 bal. 164 164 jan. 31 bal.wages payablejan. 31 bal. 1,400 1,400 jan. 31 bal.wages expensejan. 31 bal. 6,400 6,400 jan. 31 bal.truckjan. 31 bal. 17,376 17,376 jan. 31 bal.accumulated depreciation -truckjan. 31 bal. 5,068 5,068 jan. 31 bal.a. if the amount in supplies expense represents the january 31 adjustment for the supplies used in january, and $1,240 worth of supplies were purchased during january, what was the january 1 beginning balance of supplies? $answerb. the amount in the insurance expense account represents the adjustment made at january 31 for january insurance expense. if the original insurance premium was for one year, what was the amount of the premium, and on what date did the insurance policy start? amount of the premium $answerthe policy began on answerjune 1july 1august 1september 1october 1november 1 of the previous year.c. if we assume that no beginning balance existed in either in either wage payable or wage expense on january 1, how much cash was paid as wages during january? $answerd. if the truck has a useful life of four years (or 48 months), what is the monthly amount of depreciation expense, and how many months has bloomfield owned the truck? answermonths

Anew 2-lane road is needed in a part of town that is growing. at some point the road will need 4 lanes to handle the anticipated traffic. if the city's optimistic estimate of growth is used, the expansion will be needed in 4 years and has a probability of happening of 40%. for the most likely and pessimistic estimates, the expansion will be needed in 8 and 15 years respectively. the probability of the pessimistic estimate happening is 20%. the expansion will cost $ 4.2 million and the interest rate is 8%. what is the expected pw the expansion will cost?