financial project

profilegsm123

i need this in excel with NO plagiarism its a lot of work and i really need a good grade on this if you have enough time send me a message. see the attachment and be willing to do all assumptions and the checklist, see all the sheets 

 

i need to see in excel all formulas dont just calculate manually

 

heres some notes the teacher gave us , you can choose either fifo or lifo

Begining balance + purchases = Cost of Goods sold + ending balance

qty : 40,0000          182,000        =  180,000                          420000 (40k)(1.05) because it increase by 5%

$/unit   $10                  $10.40     = 1863891.89   

$400,000                  1892800

 

2,298,800/222.000= 10.354 * 180.000= 1863091

for the inventory you can uso either FIFO or LIFO 

 

sales        0                1             YEAR 2

Q         100,000    180,000    327,000

$/Q        50               61

$      5,000,000    10,980,000   

 

USE THE FINANCIAL INCOME STATEMENT FOR THIS PROJECT and no plagiarism at all.

 

  • 9 years ago
  • 20
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    copy_of__accts_project_answers_1_1.xlsx
Bids(0)